Glad it was something simple like that!

K. Brian Kelley

bk@warpdrivedesign.org

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

We're running a couple of servers with multiple instances, but that's for Active/Active clustering. Biggest issue is resource usage. As Sean already pointed out, a poorly written query...

If you know the starting point based on the primary key, you could use SET ROWCOUNT to return back X records. For instance, consider the sample table:

CREATE TABLE TestData...

To add it back, it depends on your version.

SQL Server 7:

EXEC sp_addextendedproc 'xp_cmdshell', 'xpsql70.dll'

SQL Server 2000:

EXEC sp_addextendedproc 'xp_cmdshell', 'xplog70.dll'

K. Brian Kelley

bk@warpdrivedesign.org

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

We use a VBScript job step to do our dirty work calling the File Scripting Object as Andy has mentioned. There should be some pretty basic examples at

You said you found out that the server has an E: drive, but the error you're getting sounds like there may not be one there. Can you either verify...

Yes, my organization has two of us that are DBAs that happen to be data analysts part of the time. We've also got a full time data analyst and...

It's always nice when it's a simple thing like that... but getting to the answer is often oh so annoying!

K. Brian Kelley

bk@warpdrivedesign.org

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

It depends on which function you use. If you use IDENT_CURRENT('<table name>'), then it'll return the identity value based on the last insert. If you use SCOPE_IDENTITY(), it'll...

Where I work we don't use Visual Studio to check in and out our stored procs. What we do is save off any stored procs to files and then...

I'm not having any problems when I explicitly define someone to have EXECUTE access (whether GRANT or DENY), either. What about when you deny access, even to a sysadmin...

That's where QA has saved our necks. We have a change control process where the manager wanting the change has to sign off, then it has to be reviewed...

We use the DB Maintenance Wizard heavily at my org, and we've not had much in the way of problems. It's like EM or any other tool... in the...

I've found this article to be very true. We've got three DBAs where I work. One was solely a production DBA, but he's now doing DTS packages and...

What we do is only the keep the latest backup on disk on the SQL Server itself. All over backups are moved over and renamed on a server dedicated...