You might try:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=560&FORUM_ID=5&CAT_ID=1&Topic_Title=Copy+Logins&Forum_Title=Administration

There was a script there to copy logins.

K. Brian Kelley

bk@warpdrivedesign.org

I was able to kill an instance (SQL 7's Agent on a Win 2K Pro box) of SQL Agent, but like Leon said, it came right back. I, too,...

Here's the how to from Microsoft:

http://support.microsoft.com/support/kb/articles/q219/2/64.asp

It's been updated to cover SQL 7 on Windows 2000.

K. Brian Kelley

bk@warpdrivedesign.org

We're required to load all of our scripts into Visual SourceSafe. It does have compare functions, even between versions. Most Change Control software worth their salt have this...

Like everyone else, I'll have to say it depends. Factors like the size of your database, the average number of concurrent users, the peak number of users, etc. all...

Looking at the SQL 2K Resource Kit:

"If Memory: Page Reads/sec > 5, this is bad for performance."

Pages/sec > 0 does show it's using the paging file, but there's always going...

Is it returning an error or just not populating the field?

K. Brian Kelley

bkelley@agfirst.com

patilds,

I'm a little confused by your statement as well. I would think that there could be a blocking issue.

K. Brian Kelley

bkelley@agfirst.com

Did you try:

Dim MeatCost_1

Dim MeatCost_2

Dim MeatCost_3

Dim MeatCost_4

Dim MeatCost_5

MeatCost_1 = DTSSource("meatcost__1")

MeatCost_2 = DTSSource("meatcost__2")

MeatCost_3 = DTSSource("meatcost__3")

MeatCost_4 = DTSSource("meatcost__4")

MeatCost_5 = DTSSource("meatcost__5")

DTSDestination("meatcost_1") = MeatCost_1

DTSDestination("meatcost_2") = MeatCost_2

DTSDestination("meatcost_3") = MeatCost_3

DTSDestination("meatcost_4") = MeatCost_4

DTSDestination("meatcost_5") = MeatCost_5

You shouldn't...

So you're issuing the following in your ActiveX script and everything displays properly:

MsgBox DTSSource("meatcost__1")

Is that the case?

K. Brian Kelley

bkelley@agfirst.com

To expand upon what Leon has already written, you can use RAISERROR to customize your message. For instance:

USE pubs

GO

UPDATE authors SET au_id = '172 32 1176'

WHERE au_id = '172-32-1176'

IF...

Sounds like what you need to do is create a MAPI profile that connects to the SMTP Server via POP3. Enclosed is the Q article from TechNet which talks...

SQLMail replies a MAPI profile belonging to the same account as what the MSSQLServer service is running under, yes.

With Win2K, there's also CDO for Windows 2000, which is am improvement...

Andy makes a good point. If you do copy it to another server, the sysadmin role by default is going to get dbo rights. I didn't think about...

Wow. Andy's suggestion is probably the best one. How often is the data being added to or updated? Also, is there a possibility of keeping some tables...