I am using SQL 2005
I had a question regarding instead of triggers. Can we have all 3 triggers
on a table like 2 ´normal triggers and 1 instead of trigger
Trigger for Insert

Can someone please tell me if the following is possible to achieve using
Try-Catch?
I'm using try-catch for general error handling.
But i'd lilke to use it for handling certain business rule failures in the

i do have the problem that i do not see activity monitor beneath management
in sql2008 on a freshly installed box even i am logged in with full
privileges (bulkadmin, sysadmin, etc).
any idea why?

For a database running SQL Server 2000, we get a field containing date &
time.
We find that the data type is INT 4 and the content in that field are
integers like

I have ms sql 2005 sp2 64 bits.
I got the below error when right click on the table via the object explorer and selected the Design option.
Any idea how to resolve it?
Object reference not set to an instance of an object

Any suggestions on data modelling tools besides Visio?

I have two windows 2003 server with 6 instances of SQL 2005 64bit
installed on each of them:
Server1:
Server1\dev

I need an alert when a cluster fails over.  I tried creating a WMI alert  -
SELECT * FROM MSCluster_Event WITHIN 10
But it doesn't seem to see the sql group failing....it can't monitor itself
apparently.

I am using SQL 2005
I had a question regarding instead of triggers. Can we have all 3 triggers
on a table like 2 ´normal triggers and 1 instead of trigger
Trigger for Insert

We have an SQL Server 2005 server that is running at 95% and we can't tell
which process is causing this to happen.
The Activity monitor shows the processes and when is runnable (not sure if
that means it is running or not).  I have tempdb whose status is runnable

I have installed SQL Server with the following:
Collation = Latin1_General_BIN and the
SQL Sort Order = 0.
This is a vendor application and the vendor needs the Collation to be

I am using SQL 2005, I have a question regarding notification,
our SQL 2005 has a curitial role in our enviorment, that is why I would like
to get a E-mail notification, when ever mssql service or sql agent service
crached.

Wondered if anyone could help with an upgrade problem that i have.
We have a 64bit sql 2000 machine that we are trying to upgrade. We did
a test by moving the machine into a 32bit 2005 environment on a server
that has 8 logical processors (4 dual core) and 16gb ram. The 64bit

the collation of my database was: "Latin1_General_CI_AI".
I changed it for "Chinese_PRC_90_BIN" because I want to store chinese
and english stuff.
I used this SQL command:

Hey folks,
We have recently made the move (in dev at least) to SQL 2005.
I have recently discovered that I am unable to create a default schema (dbo)
for a windows group. Am I forced to manipulate permissions for each login