Hi, everybody.
We have a question from our potentialy custommer about sql server 2005 (not
Express version)  license ,he think about licence per processor or per user
.

Hi, is there a query i can run that will return SP write stats ?
Thank you

I'm analizing a corporate schema for ours databases using clusters as HA
solution.  Actually I have doubts about if is better to have multiple
instances of SQL Server and one database in each one, or one instance with
multiple databases.

i plan to rename the sql server. anyone can help me on the following:
what are the impact to sql server and its databases if i rename the server?
what is the best approach to rename the server?

i am trying to install sql sever 2008 enterprise evaluation on my windows
vista ultimate. i download the iso file, burn it and then run setup.exe. i
got the following error
"

I want to run on the local machine.
Trying to turn on Shared Memory.
1.
Instructions to enable a server network protocol are:

We are using sql 2000, then every night we have an insert procedure to load
employee info into a table db1. During the day, we have seperate sp1 to
search db1, it is very slow. Then we added the index for search on db1, it
gets faster. However, it affects the loading process at ...

Looking at the windows performance monitor i can see the average disk queue
length jumping especailly high, looks like the database is locking out while
it occurs, which makes me think its a file size increase problem. Running
the following query:

In SS 2005, using Management Studio, how can I reset the sa password.  If
not in MS then how in script?
thanks,
Gary

I have both sql 2000 and sql 2005, I need to know what is the best way to
audit the database changes.
I don't want to hurt the production performance.
Appreciate any suggestions,

Hi..
We have a SQL 2005 DB set to Full Recovery mode. We make full database
backups everynight.
I have a few questions about transaction log (ldf) files..

Greetings.  I am seeking a web site that exhibits the following dynamic data
format:
The user is able to select data to be displayed, hit a submit button, and
the data is displayed.  If the user then selects different data and submits,

I analyze a trace from production, shows an SP with certain parameters needed
30 seconds of CPU, out of a duration of 60 seconds, doing about 600k reads.
On my dev box, the same code and the same data needs 10 seconds of CPU out
of a duration of 10 seconds, doing about 600k reads. ...

Our SQL server 2000 is nearly out of disk space, what we want to do is use
Enterprise Manager to backup the database to another server.  
However on the selection list you cannot select a mapped drive letter only
the drives installed C,D,E,F. We cant backup to the local drives due ...

Is there a way to upgrade my SQL version from Standard to Enterprise without
doing an full uninstall and reinstall?
I have several servers that are running developer edition and standard
edition and I want to get them all to Enterprise edition.