identitycolumn.blogspot.com
Identity column: If Isnull Question
http://identitycolumn.blogspot.com/2012/03/if-isnull-question.html
Friday, March 30, 2012. I have a SP I am trying to set a value for a variable in. The default value. For the variable is Null. If there is not parameter passed I want to do an If Isnull statement to set. The variable in the SP, except I keep recveiving an incorrect Syntax error. If any one can suggest a fix I would greatly appreciate it. Here is my statement. If IsNull(Convert(VarChar(50), @.Client), Set @.Client in ('HUD601Solomon',. 039;Citi Special Servicing', 'HUD601SalomonDeal3'). If my cube dont ha...
ignoringspaces.blogspot.com
Sql Ignoring spaces: impact of changing recovery model on a database that is currently
http://ignoringspaces.blogspot.com/2012/03/impact-of-changing-recovery-model-on.html
Friday, March 30, 2012. Impact of changing recovery model on a database that is currently. I'm running sql server 2005 standard edition. We have given up on sql. Server replication for various reasons and are gonig to implement. Transaction log shipping. I need to switch the database to "Full". Recovery model but owing to a fascinating combination of circumstances. And indecisiveness the server has had replication disabled before the. Before I get a replication strategy going to I want to go to FULl.
ignoringspaces.blogspot.com
Sql Ignoring spaces: Impact on replication when a server goes into standby mode
http://ignoringspaces.blogspot.com/2012/03/impact-on-replication-when-server-goes.html
Friday, March 30, 2012. Impact on replication when a server goes into standby mode. We have the following scenario:. Server A replicates Database A to Server B. Server C has Database A on it as well, but in standby mode. We are applying the transaction logs generated by Database A on Server A to the database on Server C leaving it in standby mode each time. When I start to use Server C, can I backup its transactions and apply them to Server A, and then have those transactions replicated to Server B?
hyperthreadingdx.blogspot.com
hyper threading: I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33
http://hyperthreadingdx.blogspot.com/2012/03/i-got-following-error-error-823_6578.html
Friday, March 30, 2012. I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33. I got the following error. Error: 823, Severity: 24, State: 4. I/O error 33(The process cannot access the file because another process. Has locked a portion of the file.) detected during write at offset. 0x0000000a796000 in file xxxxxxxxx.mdf'. What happened to my database? Because my table size is 4.5G . Thx You can download Filemon from sysinternals.com. Subscribe to: Post Comments (Atom). I got the foll...
hyperthreadingdx.blogspot.com
hyper threading: I got Distribution Agent failure
http://hyperthreadingdx.blogspot.com/2012/03/i-got-distribution-agent-failure.html
Friday, March 30, 2012. I got Distribution Agent failure. I got Distribution Agent failure. However everything working correctly, its allways red x on distribution. I have transactional replecation between two virtual computer, i replecate. All tabels from my database, everything work correct however i got red X on. Replication monitor, on distributer agene. Also i didnt find any errors in. History of distributor agent. When i change some rows on publisher and after this run agent i see the. Recommended ...
hyperthreadingdx.blogspot.com
hyper threading: I give up on this one...
http://hyperthreadingdx.blogspot.com/2012/03/i-give-up-on-this-one.html
Friday, March 30, 2012. I give up on this one. I have tried and tried to get this to work and I'm doing something dumb. I'm going to include sample data and my format file. Can someone help. Me figure out my dumb mistake on a bulk insert using a format file? Don't worry about data types, I'll handle that later. Thanks a lot! ID,NAME,SPEC ORIGINAL,SPEC,CATEGORY,ADDRESS1,CITY, STATE,ZIP,PHONE,COMPET. ITOR,PLAN,HARVESTDATE,EIDs,EIDCount,sourceIds,minS core,maxScore,hasContr. Y,Y,Y,Y,Y,0, 3,G,1, ,netcomp1.
hyperthreadingdx.blogspot.com
hyper threading: I hate the maintenance CleanUp task :=)
http://hyperthreadingdx.blogspot.com/2012/03/i-hate-maintenance-cleanup-task_30.html
Friday, March 30, 2012. I hate the maintenance CleanUp task :=). I have a backup database task that runs at 4 am. I added a maintenance CleanUp task pointing to the right folder. I checked the include first-level subfolder box, and delete files based on the age of the file at task run time. I specified delete files older than 1 day. But the cleanup task is not working, I have to manually go a delete the files myself. Am I missing something? Should I run the maintenance task first? By not being able to au...
hyperthreadingdx.blogspot.com
hyper threading: I got 2 question, if tempdb is full, how to fix it? 2. if I have f
http://hyperthreadingdx.blogspot.com/2012/03/i-got-2-question-if-tempdb-is-full-how_30.html
Friday, March 30, 2012. I got 2 question, if tempdb is full, how to fix it? 2 if I have f. I got 2 questions, if tempdb is full, how to fix it? 2 if I have full backup. Yesterday and no transaction log today and I delete data by accident, is. There any way to recover it? Http:/ www.aspfaq.com/show.asp? Http:/ www.lumigent.com/ - explorer log for sql. Iter" Iter@.discussions.microsoft.com wrote in message. News:A292519F-B554-4193-9437-9B74EAE07151@.microsoft.com. 2 if I have full. I got an err msg. I get ...
hyperthreadingdx.blogspot.com
hyper threading: I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33
http://hyperthreadingdx.blogspot.com/2012/03/i-got-following-error-error-823_2192.html
Friday, March 30, 2012. I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33. I got the following error. Error: 823, Severity: 24, State: 4. I/O error 33(The process cannot access the file because another process. Has locked a portion of the file.) detected during write at offset. 0x0000000a796000 in file xxxxxxxxx.mdf'. What happened to my database? Because my table size is 4.5G . Thx You can download Filemon from sysinternals.com. Subscribe to: Post Comments (Atom). I got the foll...
hyperthreadingdx.blogspot.com
hyper threading: I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33
http://hyperthreadingdx.blogspot.com/2012/03/i-got-following-error-error-823_30.html
Friday, March 30, 2012. I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33. I got the following error. Error: 823, Severity: 24, State: 4. I/O error 33(The process cannot access the file because another process. Has locked a portion of the file.) detected during write at offset. 0x0000000a796000 in file xxxxxxxxx.mdf'. What happened to my database? Because my table size is 4.5G . Thx You can download Filemon from sysinternals.com. Subscribe to: Post Comments (Atom). I got the foll...