Vijai,

I think it would depend on the reason for the trigger in the first place?

Matt.

Nice to hear!

Thanks,

Matt.

I'd do what MarkusB said, but if not, id recommend the following script as it can also send a NET SEND message to the user letting them know whats happening:

Hi Isabelle,

Sorry, i hope i have worded it a bit better this time.

We had our production cluster "Cluster A" that housed our live systems. We then used log shipping...

Hi Steve,

Put the use database statement mentioned above directly after the create database. This will ensure any statements after the use database statement will be aimed at the correct...

Take a look at this KB Article:

http://support.microsoft.com/kb/315886

Scroll down and take a look at Q12, Q13 and Q14 in particular.

I have seen this happen before when Outlook is waiting...

Does your last step use SQL Mail?

Matt

Nice example Carl, thanks.

Matt.

Isabelle,

We did something similar at one of our sites. We had an application that hammered the main SQL Server cluster with some of the reports it ran. We had...

I dont think you can using any of the built in functions.

You could do this using a User Defined Function that returns a varchar string in the format you requested.

Matt.

So you dont see 'MSSQLSERVER' in your list of running services?

When you installed SQL Server, what account did you set the services to run as? Is the account a local...

nyboy,

What database are you trying to connect to, im guessing SQL Server 2005? Whats the exact error message you get?

Feel free to PM me the error message as...

Hi,

Can i ask why you need to seperate the data into different tables when you have a date column?

Would it not be easier to have a table that holds...

Try this, it should work. The only thing i have changed is ive added the 'GO' after each statement.

-- Mitch Curtis

-- A2view.sql

-- Set the active database to KWEA.

USE KWEA;

GO

-- Drop...

Hi Dom,

If your looking for some test data, give this tool a shot:

http://www.red-gate.com/products/SQL_Data_Generator/

Its pretty good for generating realistic data for testing whilst studying for 70-431.

Matt