Viewing 15 posts - 38,911 through 38,925 (of 39,466 total)
I'll take a look, but my guess it VB is reporting the number of rows back to the application, not MSDB.
Steve Jones
November 19, 2001 at 10:18 am
you can include them in the URL as REQUEST parameters. as far as calling form SQL, you need a client that will do this. There is an object model for...
November 19, 2001 at 10:16 am
In SQL 2000, you can use the Dynamic Properties task to change any value in the package. This can some from a db, ini file, global variable, etc.
Steve Jones
November 19, 2001 at 10:12 am
November 19, 2001 at 10:10 am
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
Viewing 15 posts - 38,911 through 38,925 (of 39,466 total)