Sorry I don't think you can trace it, unless you had some kind of auditing in place, especially if you don't know the exact time it was run.

I have...

If you audit the DDL changes you should be able to find out what changes the login ID permissions see

http://www.simple-talk.com/sql/sql-server-2005/sql-server-2005-ddl-trigger-workbench/

scptxfr.exe is not in SQL Server 2005

DECLARE @sql VARCHAR (100)

SET @sql = 'sqlcmd -S server -q "select first_name from pubs..name"'

EXEC master..xp_cmdshell @sql

Can you get the text files into a better format, ie:- comma separated, fixed width, xml ?

Try:-

SELECT convert(sysname,DatabasePropertyEx('database name','Collation'))

Ask them for a list of satisfied customers that you can contact to see if they are satisfied with the performance, support and scalability of the product. I've yet to...

Totally depends on the volume of reads and writes on the table, and how it is being used, size of database, performance of hardware etc.. If the database is heavy...

I think you may need to set up database mail, in the following script that I use

1. search and replace ServerName with your servername,

2. add your mail server...

Try creating an interim table in SQL Server with the correct number of columns but all fields as say varchar. Import to the interim table, then copy data from the...

The database will increase in size as it is used up to the maximum space available which is your 10 GB drive, the 10% default is acceptable on really small...

Look up DATEADD in BOL DATEADD(Day, -1, @startdate) etc.. might so the trick

You need to alter the syntax of the time variables so you drop the time element making midnight the default ie:- BETWEEN SELECT CONVERT(CHAR(8),GETDATE(),112)

AND SELECT CONVERT(CHAR(8),GETDATE()-1,112)

The dynamic connection in the example does work to connect to 2000 as well as 2005 servers, but often the syntax of the query you run on a 2000 server...

This has the makings of a permissions issue are are both servers registered in EM using the same user name?