That was what I was afraid of...

BTW, the snapshot takes about 8-9 hours, but a Baskup/Restore takes 2-3 hours, and that's after optimizing the snapshot using -UseInprocLoader and multiple BCP...

You could use the undocumented procedure "sp_MSForEachDB"...Like this:

 

exec sp_MSForEachDB 'exec myProc ''?'''

It will replace the "?" with the name of each database and execute the...

Fixed server roles cannot be created, but you can assign a server role to a server login. I believe the only server role that has db_owner/dbo rights in all databases...

You can grant the db_owner role in each database to a specific user.

-Dan

Try this:

DECLARE

  @Pallet_Name  VARCHAR(10),

  @Pallet_Num   INT

SET @Pallet_Name = 'PAL'

SET @Pallet_Num = 12

SELECT 

  Pallet = 

    @Pallet_Name...

A "SELECT INTO #temptable" will still lock the system tables in tempdb while it creates the table. A prefered method in SQL 2000 is to use a table variable (declare...

I may be misunderstanding what you need, but you can select the type of connection for the user/client based on the connection string. If you pass a uid and password,...

Here are some useful links relating to join types:

http://www.sql-server-performance.com/mb_sql_server_joins.asp

http://www.sql-server-performance.com/hints_join.asp

-Dan

If I understand what you are trying to do, give this a shot:

 

SELECT 

    l.[date],

    l.contractornum 

  from...

You can use these to system functions/procs to tweak the resource usage:

-- View Current settings...

SELECT FULLTEXTSERVICEPROPERTY('ResourceUsage')

-- Change current settings (1=background; 5=dedicated)

exec sp_fulltext_service 'resource_usage','3'  

-Dan

As far as the "delete" errors go...you can create a custom Agent Profile for the Distribution Agent. On the -SkipErrors property you can put 20598. This error is "The...

The simple recovery model is well-suited for DBs that are mostly read-only, or where changes are applied in bulk and can be redone programmatically if needed. Obviously not a...

I haven't looked in detail at all the postings, but from past experience I've found when doing outer joins and trying to limit the results with a WHERE clause, you...

Thanks for the insight Brian.

-Dan

Would it then be recommended to create a SQL Server user with the same exact rights as the NT Group. Then use that SQL Server user only for connecting...