Viewing 15 posts - 38,896 through 38,910 (of 39,456 total)
Don't know if this is a problem as I don't use replication that much. I'll ask around.
Steve Jones
November 19, 2001 at 1:28 pm
On this page:
http://www.microsoft.com/sql/howtobuy/pricing/default.asp (check out the CE section before licensing)
Looks like you can download it, but licensing is similar to the MSDE.
Steve Jones
November 19, 2001 at 10:36 am
Checked through BOL. Only shows EM and DMO as auto solutions.
For DMO: Here is the section from BOL.
Script Method
The Script method generates a Transact-SQL command batch that can be used...
November 19, 2001 at 10:33 am
Interesting debate. Haven't ever admin'd Oracle, though I did develop against v7.
Personally, it has almost always come down to cost for my companies. Oracle has been substantially more expensive. The...
November 19, 2001 at 10:26 am
It has been problematic for me. In VI 6, there were bugs with managing stored procedures. I heard these were ironed out, but haven't checked it since SP3.
Also, it only...
November 19, 2001 at 10:20 am
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
Viewing 15 posts - 38,896 through 38,910 (of 39,456 total)