Hi Sql sever experts,
My database is corrupted. If I restore from a backup, the new database has
the same behavior as the original one.
If I use export/import, the new database behaves correctly.

Please,
how can I monitor Error-Log of "Microsoft SQL Server" (version "2005, Standard
Edition, x64") and send email when record with text "deadlock victim=" was added?

  I haven't dealt with buying or installing sql server for quite a
while. I've just purchased a new computer and want to be able to
develop systems that will be hosted on web host that has sql server
2005 (not sure who yet). I'll be running these systems intially on my

i'll appreciate if some body can tell me that sql 2000 can take advantage of
a single or multiple multicore cpus or can only support old physical single
cpus.
i am sql 2005 supports multi core, kindly re confirm.

Are many days that I've this problem, and I can't to resolve it :-((
I've a Table named "Activity" with
Date - DateTime type
Description - Varchar type

When I click one of database, I got some IE script error:
line:307
char:unspecified
URL:\c:\progrm~\...........tab.hmtl

Microsoft recommends the following for memory configuration. Can help
me understanding this statement with an example.
When you allocate memory for clustered SQL Server servers,
make sure that the summed value of the maximum server memory settings

I am trying to set a database to single user with rollback to get exclusive
control so I can restore it but this command is hanging against spid -2
(orphaned DTC). Any ideas?
This is SP2 build 3239.

Hi
I am installing sql server 2000. On "Services account" setup screen, I want
to use a Domain user account.
What should be a Domain user account. By default my username is on the

I have a stored procedure that backs up transaction log from a database.  You
pass the database name and a path where you want the log backed up to to this
stored proecdure.  what I would like to do is set up another stored procedure
that would could pass the name of all of the ...

Hi SQL server experts,
I'm trying to restore from a backup file.
I need to restore the datafile and logfile to different names.
I modified the  options page, changed the 'Restored As' file name.

I am running the following reindex, and I have question on the fillFACTOR
paramater.
When I specific FILLFACTOR = 20, does this mean it will leave 20% free space
on the index page?

I have a SQL 2005 production server that does not have all the components
installed. One of my developers wrote an SSIS package but when she runs it on
the server it errors out with:
Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW

If I have an Index with the fields a,b and c and in the query the where
statement is as follow: where b=something and c = something and a =
something
Does SQL Server convert this to the right order a,b,c as  a covering index

We created 100 databases for 100 customers using SQL SERVER 2005 enterprise
edition. Customers need use SQL SERVER Client Utility connect to the Server
to maintain their databases. We hope each customer can only see his(her) own
database name(icon) in SQL Client Utility. Other ...