What about traces? You can set up a trace to log your logins specifying NTuserName and LoginName and also a DatabaseName or DatabaseID field in the Data Columns for the events...

Did you uninstall all instances? Do you have Client tools that you installed after you uninstalled Enterprise? You don't have an option for the Default instance for example if no server...

I also used a read-only login on the local server and mapped it to a read-only login on the remote server. It still works. I am opening a new connection...

Hi,

I am working right now on getting data from my linked server (that works) so I tested your cases as well:

Settings: I provide a correct login and pasword for the...

If you have SQL Servers list in the database you may run a query that will get a servername from the database, append strings before and after and output in...

For some reason it posted my reply 2 times. I did not know how to delete here. Just edited

Hi,

first of all, are you hiring or are you going to the interview yourself?

second, is it a dvelopment DBA position, I mean, for a DBA to support database development...

To mdamera:

Thanks a lot!

I understand I need to copy everything from the Data directory, Master DAT and LOG files included, so I don't neeed to to somehow attach a...

The questions are:

1. You say your Enterprise Manager is on Windows 2000 and Windows 2003. But where is your SQL Server installed? Enterprise Manager is a front-end client tool. Where...

I learned yesterday of the website for connection strings named appropriately:

http://www.connectionstrings.com/

Go to this website, click SQL Server and then click SQLConnection (.NET). There are several connection strings for standard...

Jon,

As I say, I would like to know myself If we can install 6.5 on Win2K. Why not one of us just try?

After that you may use SQL query...

Here is a part of the upgrade plane for 6.5 to 2000 that deals with Restore:

Restore SQL Server 6.5 databases

I don't know. Why? I did my database upgrades on the test server by installing SQL Server 6.5, Installing Service Pack 5a for SQL 6.5, creating a new database of the...

AJ may have a good idea. Detach a database.

Then in Query Analyzer run EXEC sp_attach_single_file_db with parameters like here below. You will specify ONLY a database file name and it...

Jon and Steve,

It is not even funny. I was going to ask the very same question. I do need to know if I can run SQL Server 6.5 and SQL...