Agree with Brian. You can do that change in a loop too, but its a lot more work. Way more than its worth in my opinion.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Typically happens with sql logins. They will have one id on the original server, a different id or not exist on the new server. Set up your logins first, then...

Did you find an advantage to textcopy over using an ADO stream?

Andy

http://www.sqlservercentral.com/columnists/awarren/

It's normal and expected for SQL to gradually acquire all the RAM alloted/available to it. It uses this to cache data and query plans. Stopping the service means it has...

If you just need a marker file, you can do xp_cmdshell 'dir > flag.txt'.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Triggers are set based, they fire once per transaction, not once per row, so anytime you declare variables to work with you should plan on using a cursor. In this...

I dont think so.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Need some type of loop. You can use VB and do something like this:

'open connection goes here

set rs=cn.execute("Select * from sysobjects where .....")

do until rs.eof

cn.execute "alter table "...

Totally agree that the scale issue is worth discussing. Not sure that you'll see the affects of not enough ram in buffer cache, it tends to stay in high 90's...

Looks like a different scale.

Im curious, why would you want a perf alert on this? I agree its worth checking, but not real time.

Andy

http://www.sqlservercentral.com/columnists/awarren/

If you're just looking for blocking I find sp_who convenient. I'll probably get some argument on this, but I think generally when you're using sp_lock you're in the weeds. Typically...

Log shipping is only supported in Enterprise, but the scripts to do it where included in the SQL7 section of the BORK (BackOffice Resource Kit). It's fairly mechanical - do...

Not getting the same result:

Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL$ONE\data\helloworld_Log.LDF' may be incorrect.

New log file 'c:\program files\microsoft sql server\mssql$one\data\helloworld_log.LDF' was created.

Is the file actually getting...

Sure. Certain amount of clean up has to be done, depending on the type type of index. Not sure why you'd be dropping your pkey very often?

Andy

http://www.sqlservercentral.com/columnists/awarren/

I don't know of any limitation in the driver, though there may be. In earlier iterations of ADO/DAO it was necessary to "chunk" the data, ADO streams do away with...