Viewing 15 posts - 39,166 through 39,180 (of 39,717 total)
sp_lock doesn't work?
This should return the sPId and the objid and type. As for matching these with specific rows for an insert, that might take some doing. The resource column...
November 19, 2001 at 10:08 am
Hey!!!
Where's our link!!!!!!!!!!!!!!!!!!1
BTW, Nice answer to this question.
Steve Jones
November 19, 2001 at 10:06 am
November 19, 2001 at 10:04 am
In SQL 2000, you can do this:
declare @t table (myid int)
insert into @t select 1
select * from @t
The reason that you cannot specify a table is that the parser is...
November 19, 2001 at 10:03 am
Andy has an introductory article for this.
http://www.sqlservercentral.com/columnists/awarren/dmointro.asp
There are third party products that can do this as well.
Steve Jones
November 19, 2001 at 10:00 am
I'd agree with Paul, though I'd recommend building a table (can be temp) and dropping the results of sp_who2 into it. Then you can get a list of users.
You could...
November 19, 2001 at 9:56 am
I ran a quick trace on sql 2000 and didn't see what EM is running? Why not use EM?
I am sure you can script something using the system tables, but...
November 19, 2001 at 9:54 am
For msdb, try removing the user.
For model, not sure. Can you change it as "sa"?
Steve Jones
November 19, 2001 at 9:37 am
Haven't seen anything like this. Can you provide more information? What was the server doing? What happens if you select * from Quary Analyzer?
Steve Jones
November 19, 2001 at 9:35 am
November 17, 2001 at 7:53 am
You have to change the address at the mail server (for all mails).
Alternatively, you can use CDO/CDONTS to generate the mail.
Steve Jones
November 16, 2001 at 4:12 pm
Not that I know of. I thought MSDE was licensed in a similar manner to Access runtime.
Steve Jones
November 16, 2001 at 9:22 am
November 16, 2001 at 9:20 am
November 15, 2001 at 3:27 pm
Be sure it is a "good query" (no cross joins, etc). If you are truly building such a huge query, you may run out of resources.
Steve Jones
November 15, 2001 at 2:50 pm
Viewing 15 posts - 39,166 through 39,180 (of 39,717 total)