sqlserver12345 (2/10/2010)

Server: Msg 156, Level 15, State 1, Line 13

Incorrect syntax near the...

The only problem with this is that you do not get the actual error message... you will get the variable holders in the string in sysmessages, instead of the actual...

Here's one method. The tally table that Lutz mentioned would also be very efficient.

-- first, notice how I create a table and populate it with the test data?

-- This makes...

you know, I do seem to recall reading something somewhere about an undocumented command that might let you recover a database from a backup made after the database got hosed......

In case this helps anyone else, here are the amazon links to these books:

"Information Modeling and Relational Databases" by Terry Halpin

"Practical Issues in Data Management" by Fabian Pascal

C.J.Date's "Relational Database...

David,

Thanks for taking the time to make these recommendations.

On your first question of the datetime/smalldatetime... you need to look at how the underlying data is stored. Both are stored as a real number... for instance,

select convert(datetime, 12345.785215)

returns...

sounds like you need something like:

DECLARE @SourceA TABLE (

[ServerName] [varchar](50) NULL,

127.0.0.1 [varchar](50) NULL

)

DECLARE @SourceB TABLE (

[ServerName] [varchar](50) NULL,

127.0.0.1 [varchar](50) NULL

)

-- insert the sample data

-- notice how it's in...

probably because those tables were scripted out without the extended properties, then when run...

CirquedeSQLeil (2/9/2010)

Those two tables, no. They are tweener tables. They were technically shipped with SQL...

select *

from sys.tables

where is_ms_shipped = 0

SQL Dude-467553 (2/9/2010)

Schadenfreude-Mei (2/8/2010)

Set up another remote machin with vpn and try that, bu if other users are fine, then its...

While you're looking at robocopy, you might want to look at forfiles.exe also.

On most of our new servers, we have enough space to maintain several days backup history, so I...

Excellent question. Then I noticed who the author of it is, and realized... but of course!