I'm just beginning to learn PERL and finding uses for it. Would you mind posting your code for paging?

For some reason, I find I need to set this when I install a new instance:

I think there is a checkmark in the Linked Server properties, but the setting gets...

I'm not sure if I will be any help, but I am interested as my company will be doing the same migration soon.

I have used exec sp_change_users_login with the 'auto_fix'...

Hi Chris -

Is your issue that performance is slow or that the actual query doesn't work at all?

Might take a look at the SQL Books Online page below.  It shows...

Straws are all, I think, I have before the server gets formatted and I try again.  Unfortunately, there were no errors in either database.

I'd also thought that maybe it was the...

I've tried that many times.  I have also deleted the registration and created it, same error.

An owner of a stored proc can grant rights, but it can only grant rights to logins that already have access to the database in which the stored proc resides.

from...

Also from BOL:

Permissions

Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.

...

Is the name of the table or view owner. owner is optional if the...

Only if that user exists in that database

From Books Online (BOL):

When a permission is granted to a SQL Server user or Windows NT user account, the specified security_account is...

We use it.  I use it for every one of my databases.  I have 6 servers in one location and one in another and have it installed on all 7. ...

Theoretically, Line 5 should refer to the line in your code where the error is.  Sometimes that works for me, and sometimes not.

Usually in a situation like this, I just...

Hey Greg -

I found this at

http://www.sql-server-performance.com/sql_server_configuration_settings.asp about half way down the page.  I never configure specific settings for Server memory unless I am on a system with 8GB or...

SQL Litespeed replaces the native SQL Backup utility.  It does not write directly to tape.  It writes to disk and then you can use your usual backup software to backup...

Hi Chris -

There are a couple of tools in the Resource Kit that you can use.  See http://www.sql-server-performance.com/resource_kit.asp

for a description. Not free, but you may already own a copy.

Michelle

I launch a *.reg file with the information in it.  Below is a sample for Windows 2000.   It adds in the name and the ODBC entry of a SQL Database.  I...