RE: Ronald Reagan, 1911-2004
Use SQLServerCentralgoUpdate PoliticalviewpointSet President="Ronald Reagan', Opinion='Good'where opinion='appropriate' Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'Politicalviewpoint'
2004-06-08
import
RE: Migrating SQL Server Jobs
There is a DTS task in SQL2000 to transfer jobs. The source can be a SQL 7 server and you can select the specific jobs you want to transfer.
2004-03-03
RE: Backup slows system down too much
I would verify whether the performance decrease was caused by the backup. You may consider to perform full database on weekly basis and do the differential backups for the rest days. Perform differential backup should be fast in general than the full backup. But you can't use maintenance wizard to do it, you have to […]
2003-12-12
1 reads
RE: Recovering after Log drive fails
Can you please tell me how this works in detail? I am thinking that if you have a full database backup and some log backups and your log drives goes down with every log entry after your last log backup, then it is not possible to recover the database to the last commited transaction and […]
2003-08-12
RE: SQL query help
In that case can you post the table definition and some sample data in that format and is there a maximum number of 'Comp' values?
2003-08-07
RE: linked server status
My Bad, I ment to say need to check for SQL Server up and running, but thanks i to complete that check as well. So far, I am thinking that using a script is the only way, it seems that SQL Server still believes in the perfect world where servers are always up and everybody […]
2003-06-25
2 reads
RE: Stored Procedure ?
in your pass-through query, you should say Exec UpdateInfo '1432' and that should work. You have to set up properties for the connection in your pass-through query, do not forget that.
2003-06-19
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers