When I use the StartEvents() method my application hangs.
There is even no timeout, I need to kill the application to stop it...
Microsoft.SqlServer.Management.Smo.Database.Events.StartEvents();

I need to change the collation of system databases on an SQL 2000 Server.
From the BOL and KB it appears the steps would be:
1. Find the original SQL 2000 CD (yuk, what about SPs, patches?)
2. Copy "data" folder from the CD to a local drive and attrib -r *.*

Hey Folks,
OS: Windows 2000 SP4
SQL 2000 Advanced SP3
I have a peculiar problem, one I have not experienced before. I have a

I am in need of assistance.  At present I have SQL 2005 DBs stored on a SAN
RAID 5 array that is near full and not performing at its best.  It has been
decided to add 4 new SCSI disks to our SQL box and create 2 RAID1 arrays, 1
for the .mdf and other executable files and the ...

hello ng,
we got a weird error here stating 'invalid column PKtemp' that occures
sometimes (!) in the trigger down below.
I cant see any reason for it. After investing a bit on temorary tables i

Using sql enterprise 8.0 to perform database maintenance and when trying to
restoring a backup we appear to have local backup files having been generated
- these are not part of the maintenance plan and appear at non logical times.
The maintenance plan calls for full backup once a ...

I use the SQL Server 8.00.2039 - SP4 (Standard Edition) to store data in
Greek language. This data are retrieved from a site which use the “Greek
(Windows)” encoding (in html file: charset=windows-1253).
I decided to change the encoding and use the Unicode for my web pages. This

We are running SQL Server 2000 standard edition on Windows 2003
Enterprise Edition. From what I can tell, SQL Std is limited to 2GB of
RAM no matter what I do to the configuration of the OS. Is this
correct?

deleted table in  databes with drop objesct  wrong.
how I can recovery my table in my database.
thanks

We're in the process of upgrading from SQL7 to SQL2005 (64bit).  We've
gone from a single server to now a twin pair of powerful Windows
Server 2003 64bit machines (quad-core 2.66Ghz, 8GB RAM each).
Is it possible to have 24-hour availability (with no detrimental

I've been handed the task of cleaning up our SQL environment.  We've never
had a DBA and the databases were created by our developers.  We are running
into some performance issues with the databases.  So I'm looking into doing
the best I can with the limited knowledge I have of ...

I have a c# application which tries to insert special characters to an sql server 2005 database. Here is the sql statement:
EXEC P_InsertData ,@DataToInsert='??????????????????????????????????This is test???????,????.??????????????????????????????????  '
This is how it looks in the ...

If I look at the execution plan for a scalar function all it shows is that
SQL Server is doing a 'Constant Scan'.  I was expecting to see the queries
that are within the scalar function.
Is this expected behaviour for scalar functions?

We are looking for some good books for SQL2005 DBA
Looking more for DBA administration books or topics..
Any and all suggestions welcome..

Hi, how can I do a SQL that deletes the records from 2 tables?
example:
tblCustomer:
CodCust   Name