Lun

i using 1 forum source code visual studio 2010 .mdf file not support visual studio database version, giving error : database 'e:\aspnetforum_trial\app_data\forum.mdf' cannot opened because version 661. server supports version 655 , earlier. downgrade path not supported. not open new database 'e:\aspnetforum_trial\app_data\forum.mdf'. create database aborted. attempt attach auto-named database file e:\aspnetforum_trial\app_data\forum.mdf failed. database same name exists, or specified file cannot opened, or located on unc share. how solve can suggest? hello, version of sql server installed on computer sql server 2008 (version 655), database trying attach instance created on sql server 2008 r2 instance, trying downgrade database , not possible. have sql server 2008 express edition installed. try upgrading sql server 2008 r2 express edition. hope helps. regards, alberto morillo sqlcoffee.com ...

hello friends, the query wrote below, shouldn't giving me list of plaintiff members top based on record count 2010 bottom based on record count 2011? if use topcount function on both set makes sense(e.g top on 2010 not on 2011) but when use both (topcount , bottomcount) it's not making sense. cause see members returned not bottomcounts 2011. can please me understand cube space generating? with set [plaintiffwith>1000] as filter ( {[plaintiff].[adjplaintiff].[adjusted plaintiff]. members }, ([measures].[recordcount])>10000) select {[measures].[recordcount]} on 0, except ( topcount ( existing {[plaintiffwith>1000]}, 10, ([measures].[recordcount],[judgmentdate].[judgment date].[year].&[2010]) ), bottomcount ( existing {[plaintiffwith>1000]}, 10, ([measures].[recordcount],[judgmentdate].[judgment date].[year].&[2011]) )) on 1 from ...

hi all, we trying adding job in 1 sqlserver2008r2. whenever clicked ‘new’ add step, found following error: creating instance of com component clsid iclassfactory failed due following error c001f011 can suggest resolve issue. will fix issue? fix: cannot create, add, or edit steps sql server agent job in sql server management studio 2008 r2 SQL Server  >  SQL Server Database Engine

i trying vb.net execute code when there changes in specific table. rights on sql user should right, queue created on server when dependency.start run, event not being caught when make kind of changes in table. here alle code bits apply problem, hope can see doing wrong before loose hair :-( dim connectionstring string = "data source=nef-sql.nef.local;user id=smilesql;password=password;initial catalog=smile;network library=dbmssocn;application name=waoosmile;" dim queryupdate string = "select * smiledansam transactionid = 0" dim querydependency string = "select dansamid dbo.smiledansam transactionid = 0" public sub startdependency() if not doesuserhavepermission() printdebug("not correct userrights") end if dim cn sqlclient.sqlconnection = nothing cn = new sqlclient.sqlconnection(connectionstring) printdebug(sqlclient.sqldependency.stop(connectionstring)) ...

            i had deployed extended store procedure on sql cluster , when run 1st time extended store procedure ok. tested failover few times , run again extended store procedure. i hit error below: the description event id 0 source xp_push cannot found. either component raises event not installed on local computer or installation corrupted. can install or repair component on local computer. if event originated on computer, display information had saved event. the following information included event: timeout error:xxx.xxx.xx.xxx on port 81. error code 0 hope advice whether wrongly deploy or else miss out. thanks below quote daniel's link: using extended stored procedures , com objects when use extended stored procedures failover clustering configuration, extended stored procedures need installed on shared cluster disk. ensure when node fails over, extended stored procedure...

i have attempted report out errors @ end of etl process alerting supporting dbas of errors using ssis "send mail task".  task completes along sequenced packages, not mail out.  no logic @ time trigger, success previous task triggering task send mail.  no errors in output, , no output indicating send mail task fired, go "green".  have enable database mail , have privileges?   component configuration:   smtp connection manager - smtp server: arsocex02   send mail editor - from: messerj@arsocdev.bdev.lab.mil to: sanderss@arsocdev.bdev.lab.mil messagesourcetype: direct input expression: messagesource = "package>>> " + @[system: ackagename] +" executed at>>> " + (dt_wstr, 40) @[system: tarttime] + " user>>> " + @[system::username] + " on machine>>> " + @[system::machinename] + " errors reported errors_course_class_status_t:  " +   (dt_wstr, 50) @[user::errorcoursec...

hello, in query modify stored procedure use word description column name. sql server management studio highlights word in blue. so word keyword ? if so, what's meaning ? may still use column name ? thanks description reserved keyborad http://msdn.microsoft.com/en-us/library/aa238507(v=sql.80).aspx >>may still use column name ? yes [word description] or word_description best regards, uri dimant sql server mvp http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ SQL Server  >  SQL Server Setup & Upgrade