Hi

Sound good, but keep in mind that if the backups are stored in a format other than the usual SQL .BAK format - you need to be sure that if...

Hi

If the question you are asking is if you can have multiple instances with the same name on a network - the answer is yes.

Note: this assumes that these instances...

Hi - I agree with Gila.

Find the top 3 queries in the next few hours / days. Then run them through DB tuning wizard on your DEV or offline DB...

Hi

Can you give more details around the performance issues, have you identified that there are too many transactions per second, causing other queries / sessions to wait?

Have you identified that...

Hi

The next step you could take is to run SQL Profiler to "catch" the sql that is being sent to the SQL Server.

You will need to select the relevant filters...

Yes - the SQL 2000 data source is the same as any other.

Thanks

Kevin

As Gail said the '_' character is a wildcard.

So if you wanted to only return the 1 record then the LIKE query would be:

select * from #Like_Test where Col1 Like...

Hi - yes that sounds like a good option.

Will this work for you?

Let us know

Thanks

Kevin

Hi - you are right - you need to restrict access. Some advanced users even make use of Excel to connect to SQL and run queries that way.

I would suggest...

Hi

We are fotunate in that we have an ERP system that makes use of a single account to connect to the DB and this is a Windows account.

So users do...

You mention that you changed the server names, does this mean that 2 servers have "shared" a name?

There are potentially registery entries that are still pointing to the instance name...

Hi - yes the instance you talk of is the Named Instance and you can have many of the same of these names as the SQL Instance is actually both...

Hi Sherry

A default instance of a SQL Server 2000 or 2005 is usually the PC Name.

You can not have the same PC name on the same domian.

In SQL 2000 /...

I agree with the idea of the staging area as the following can be done:

* Load data to tables & refresh these daily (overwrite if required)

* Choose the order of...

Hi

I have an issue with Maintenance Plans that I can not save with my client tools. The error message is:

"No description found" - and a red X

But if I...