Now I'm totally lost. Why did you add the @@ERROR, and why does your message now say "Please enter", and why do I feel like this is homework?

SQL Server doesn't use IF/THEN syntax, it's just an IF (using begin/end for blocks of statements). Your "end" needs a matching "begin" as well. What is the space surrounded by...

Show us the code you have so far, and we can figure out what's wrong with it.

The syntax is in BOL under the keyword RAISERROR. Note that it's one word, and that it's technically missing an "e", but that's where it's located.

Is autoshrink turned on? Is anything reindexing the tables in question?

It might also help if we knew if this error happens every time it runs, occasionally, or just once.

Wassim, the size of your query shouldn't affect whether you can run it on a single processor. That's an internal error, so there is no magical quickfix for your problem,...

This is often caused by lock escalation on a parallel process. Have you tried turning off parallelism, either for just this query with the MAXDOP option, or on the server...

If you don't have SP4 installed, and if this is an UPDATE or DELETE query, you might want to take a look at this.

Henk, if he uses that as the default for a smalldatetime column, it will convert it right back into a date (it will lose the formatting that style 112 applied to...

As Jeff stated, more info would help, but a few things pop out. First, does the table you are inserting into already have records in it? If so, how many?...

I'm not aware of any DMVs that would return everything you need, but only a few of our servers are 2005 at this time, so I haven't had a lot...

If you only want user tables, and if you don't mind information schema view (they're system table independent), then the following will work:

SELECT

 Count(TABLE_NAME)

FROM

 INFORMATION_SCHEMA.Tables

WHERE

  TABLE_TYPE = 'BASE TABLE'

 AND TABLE_NAME <> 'dtproperties'

Note that you...

No problem at all. I was going to say you can also use the niladic function CURRENT_TIMESTAMP, but it just turns it into Getdate() anyway, so might as well cut...

Getdate() should work like a charm. Is that giving you errors of some sort?

I'm not sure if I'm following you completely, but I'll go over a few things off the top of my head.

1. The firewall needs to be setup to allow the...