FWIW, I use StarInix' free database comparison tool. Very useful.

http://www.starinix.com/sqlcompare02.htm

Based on jeff's use of a table for the pattern...

-- need a list of employee ids with a basedate set to when they start with shift_code=1, unit=1

-- this is a...

The drawback with this is that is both the OLE Automation Procedures and xp_cmdshell are disabled by...

As it happens, I found a tool for doing exactly this yesterday.

http://www.codeplex.com/ScriptDB

I will even dump bcp extracts of the data for you if required.

Although the VerifySignedByCert function can confirm that the signature matches the data, since both are simply in different columns of the same table, there is no way to verify that...

I am the only person working on a database with over 100 tables, 50 views, 150 functions and a couple of dozen procedures. I've been annoyed for some time that...

I'd be interested if anyone could come up with a way to make SYSDEPENDS reliable.

Try the following:

create table a (id int)

go

create procedure b as begin select id from a end

go

SELECT...

I also found this discussion http://www.sqlservercentral.com/Forums/Topic306817-146-1.aspx which doesn't seem to come to a conclusion but also implies that under SS2K5 losing a log file means you're SOL.

Interesting if compatibilty mode...

The conclusion seems to be that there was NO right answer from the choices given.

Also one of the first references I've found to 'DBCC REBUILD_LOG' is

http://www.sqlservercentral.com/articles/Administration/sqlserver2005dbcccommandquickreference/1628/

which has it under the...

I've never had to do this, but was put off the choice FOR ATTACH_REBUILD_LOG by the section in BOL which says...

FOR ATTACH_REBUILD_LOG requires the following:

* A clean shutdown of the...

I'm in the UK (GMT currently, no daylight savings time) it's 11:45am (approx) yet the date time option says...

"All times are GMT, Time is now 12:45pm"!

I think you've missed the point about normalization. If any of the fields of TableA can be NULL (as you say most of them can be) then it makes sense...

I was interested by the title since I've spent a large amount of time trying to get a working days calculated correctly in the past year. My requirements meant that...

I'd remember reading that somewhere.

The frustrating thing is that SQLserver won't let you write a 'non-deterministic' UDF, so the implication is that it's going to assume that if you call...