Can forum participants tell me if the following would possibly have an adverse impact:a. an OS backup in progress which was temporarily reading the event file.b. a virus checker which might have been reading the event logc. a remote reader of the server's event logd. an OS search type function which was scanning the event log for […]
2004-03-19
1 reads
You can do 10 fetches. But this will generate 10 result sets ... :create procedure aa @rowset integer as begin SET NOCOUNT ON DECLARE @pos integer, @co int DECLARE cPartners SCROLL CURSOR FOR SELECT * FROM partners OPEN cPartners set @pos = @rowset * 10 set @co = 0 goto FETCHNEXT while @co < […]
2004-03-18
Hi there,on the forums home page I saw Last post made in Discuss content..., but I can't seem to find it on the Active topics page.
2004-01-09
1 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC