That doesn't help. Because for FTPing, it would use the userid and password mentioned

exec xp_cmdshell 'ftp -s:D:\Utilities\FTP.TXT'

We use this daily. If this is not putting the file on the...

By the way... This is running on SQL Server 6.5.

Thank You Steve and DickBaker.

I donno why it had happend. I could not see any connection which is being used in the Monitor tool of DBArtisan. I killed all the...

Even when the memory is dynamically configured, You could could use MIN and MAX settings. Try setting upto 3.5 GB for MAX. Might Work....

Regards,

Murali Damera.

I am looking at the SQL Server Error Logs. My Server Name (Physical Machine Name) & SQL Server Name is the same. Which is exactly the same same it is...

yes.

If your SQL file is on C Drive and the outputfile to be created on C drive, it should look like this:

EXEC xp_cmdshell'isql.exe -S nameofmyserver -U mydbouserid -P mydbopassword...

in the earlier script, option "i" is the inputfile, option "o" is the output file. You needed to give your SQL file as input.

running ISQL.exe is one of the way...

You can execute a SQL script stored locally as follows:

EXEC xp_cmdshell'isql.exe -S SERVER1 -U sa -P PASSWORD -id:\dba\dbadmin\sql\sp_who.sql -od:\dba\dbadmin\outfiles\sp_who.out'

Hope this answers your question.

I ran into same scenario few weeks back. I checked Books Online as well. We cannot specify Server Names in SELECT statement.

Thats fine. To my understanding you <b>cannot</b> specify Server names in <b>SELECT statement</b>. Anyone please correct me if I am worng.

Yes. The max number of prefixes are 2 as follows:

select * from database.user.object

I guess in your case, peoplepc is the user, in that case, you should not use dbo again.

If...

Please check the following:

1. memory usage on the server with sp_configure when compared to what used to be. If you don't know how much is used to be in SQL...

I backup all the databases except model, Northwind and tempdb everyday. I daily bcpout the data of few system tables daily, from my SQL 6.5, 7.0 and 2000 Servers.

You might want to put this in the script library.