Take a look at DBCC SHRINKFILE, which does allow you to shrink the file itself.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.truthsolutions.com/

There is also the option of using xp_cmdshell and the echo command (> to create a new one, >> to append) at the DOS level. You may have to build...

If you have a Microsoft rep, you may want to contact them. Microsoft used to have performance information on their site for SQL Srever 7, but it's now all SQL...

SQL Compare won't track changes, but it'll do the scripting and show you the differences. It can then script to get 'em in sync. This is great to handle differences.

Here's...

Some notes from SQL-Server-Performance.com:

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

Paragraphs 2 and 3 talk about using OPENQUERY.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.truthsolutions.com/

From what you've posted, dynamic SQL is really the only answer. Robert Marda explains this in one of his articles on dynamic SQL:

http://www.sqlservercentral.com/columnists/rmarda/dynamicvsstatic2.asp

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.truthsolutions.com/

If you go out and visit:

http://www.tpc.org/

you'll see quite a range in SQL Server 2000 performance, and this is mainly due to the different hardware ranges, even though the test is...

Keep in mind that non-sysadmin jobs and uses of xp_cmdshell will be under the user account set in xp_sqlagent_proxy_account. Therefore, execution will be under that user's context. If the account...

The one thing about using Personal Folders is the email will appear successful to SQL server, because the mail was created. The MAPI client will then continue to try and...

You'll have to worry about anything that may be in the middle such as firewalls and the like. Can you give us a little more information about the setup?

K. Brian...

You may want to take a look at the following articles from Steve Jones:

Using Substring:

http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

Using CharIndex:

http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.truthsolutions.com/

Can you post the full text of what is contained in the job step history for the last job step to try and execute?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.truthsolutions.com/

It depends on how you mean use. If you mean share the exact same databases at the same time, no. (Two instances on the same server can't do this either.)...

Is the web server behind a firewall? If so, did you open up the TCP port SQL Server is listening on (You can find out which port by going to...

The first thing to check is to ensure the user account under which SQL Server Agent is running has rights to access the G$ share. Typically drive shares like this...