To ensure you get all data in the case of a null value for the variable you need to use either the 2nd or 3rd. Now I have seen situations where...

Those are the options, what was your entire string and what message did you get? Also what server version are you using?

You may need to open a SQL connection and get the names using ado but insert them into an array object in the vb script, this way you can move...

I haven't done this but I think you can add the remote trusted domains global group to a local global group then assign the local global group and all should...

Use the time function with DATEADD to set a time to wait and use a WHILE to keep looping until time is reached. The downside is the CPU cycles will...

PK is always neccessary but to have some way to create relationships or ensure uniqueness of data you need to have at least a UNIQUE CONSTRAINT. PK's are primarily to...

If you have more than 4 processors or 2 GB  of RAM then you need EE to take advantage of the hardware. However 25 million records isn't that much. I...

It can help sometimes especially if you can move to different array drives from the main one. The key is where the clustered index is stored, you have to create...

That is the default model for that database and it is reset every time SQL Server Agent restart. You cannot change this. SOme folks suggest doing a backup often but...

Is the server local or remote and if remote is that machine on a different domain than you?

There is also http://www.apexsql.com/ ApexSQL Diff and http://www.adeptsql.com/ AdeptSQL Diff

This might help a bit http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road05222002.asp

I suggest dig around in MSDN or GOOGLE for

SQLCE Programming

Sorry I haven't had a chance to play with SQLCE but are you saying your trying to attach to .sdf with EM from desktop or within CE device.

See if this...

When you say Syntax fundamentals are you meaning SELECT, UPDATE, DELETE, TRUNCATE, JOIN and such or T-SQL specifically cause there are lot's of books out there but the For Dummies...

I beleiev it is in the MSDB database in the backupset tables

backupset

backupmediaset

backupmediafamily

backupfile

Not sure if all but at least one of those.