I usually try something like this "kill & set" in an attempt to get the single_user option in before the other user/app does: use master declare @kill varchar (8000) select @kill = ISNULL(@kill , '') + ' kill ' + cast(spid as varchar) from sysprocesses where dbid = db_id('pubs') print @kill exec (@kill) exec sp_dboption […]
2003-08-13
good monday morning ?!? i have changed the CDONTS to CDOSYS and still nothing, i have the correct copy of the proc on the server. i can ping the SQL Server. i am running this in the QA and all i get is Stored Procedure: master.dbo.sp_send_cdontsmail Return Code = 0 and no mail no where.. […]
2003-07-14
Hi, I think what you may have done is to Restore the database with the 'Leave database read-only and able to restore additional transaction logs' option selected. This mode allows you to restore log file backups so that things like upto point-in-time recoveries are possible. (A traditional backup plan would comprise, for example, a daily […]
2003-07-14
1 reads
As for the non existant table, that was simply the first SP I came across that would stop on encountering the error and so I used it to illustrate a point in my article. I am glad you all liked the article. I am trying to provide examples (if nothing else) that I am not […]
2003-06-26
2 reads
We have done something like this in a Data Entry app. There are a couple of ways to do this that I can think of (we used the 1st method): 1) Use a field in the table that you increment each time the record is UPDATED. When you SELECT the data to the application, bring […]
2003-06-12
You must have SQL 2000 client tools to connect to a SQL 2000 server. SQL 7.0 tools will not connect. Cheers, Crispin
2003-06-11
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers