True, it does appear the case in query analyser...

My 1899-12-30 answer came from me using Delphi for 95% of my development - if I retrieve a 0 datetime value from...

I think Michael's point is valid - if you were using EM, make sure that you let it know it is a string as in

"2005-1-1", NOT 2005-1-1 as it...

I sometimes find a similar situation for my app just after the server has started - the DB is taking a long time to read a lot of data in...

I think it might've been the one from RedGate that I've used in the past

Good point with the identity columns - they will...

I'm not sure I fully follow your situation, but I would look to see what account your server's are running under as a service - perhaps the service account of...

I have used the diskeeper product and yes, I have also heard that it is the grander version of microsoft's bundled offering (many of MS utilities are licensed, cut-down versions...

And many things in file-based systems, like definite record numbers, simply do not exist in SQL server (and for good reason - it's a set of data.  If you want...

Or you could keep your static SQL but rather than make use of your charindex statement, which cannot use any indices, you can use a UDF that returns a table.

For...

Unfortunately replication won't do this for you as far as I know.  Replication works a treat if you have one initial source database, which is then replicated to other machine(s). ...

Firstly, someone on this forum could have possibly made the suggestion if you had the table definitions including in your post - makes things easier to understand sometimes

From memory, many cursors (depending on how they are declared) use temp tables to provide the forward/backward functionality anyway.

Also, table variables are not always entirely in memory - they too...

You should look at OPENROWSET in SQL Server Books Online or OPENDATASOURCE.

OPENROWSET returns a table, so you could issue something like

insert into OPENROWSET(....)

values(....)

OPENDATASOURCE provides you with a connection to a...

Could you please post the code of your SP?  I assume you are using the 3 part name to retrieve the data...

So you have a stored proc in db1 which...

Have you changed the name of the computer since installing SQL Server?  I recall some sort of problem that you would have to drop the old computer name and add...

SQL Server has no built in facility to perform what you are after.  You'll have to have table updates done through a stored procedure to ensure your rules are enforced,...