something like this should work for you

DECLARE @Votes table ( VoteId int IDENTITY(1,1) NOT NULL,

Presenter char(3)NOT NULL,

...

Been a long time since I looked at DCOM.

I had a document at one time of notes when I was troubleshooting it but I can not find it at...

SELECT CAST (0x000000000002F4CE AS DATETIME)

remove the single quote so it is recognized as binary and not text

you can change your us date to brit format by

convert(char(10), , 103)

or convert to us date using

convert(char(10), , 101)

select dateadd(ss, 47154, 0 )

ss being seconds

47154 being you time offset.

0 being a date of some sort (0 = 01-01-1900)

search bol for dateadd / convert and you should be able...

If you just wanted an empty database you could use dts / ssis to import the objects and not the data to a new database.

However, if you want your database...

check your ascii values. I have seen where spaces and dashes etc were saved with a different ascii value of what you enter to compare with. Though the values  visually...

Some customers might not be a good fit for your business.

However, many organizations are structured such that the sales dept needs the sale to make their numbers. After the sale it becomes...

There is almost always a way to not use a cursor.

I have used cursors in rare instances to speed up performance when the set based solution of updating millions of...

you might want to try running profiler over the database to try to figure out what user / procedures are causing the blocking.

Then find out how the user is using...

If you have 1 connection for each spreadsheet (20)

1 connection for your server

20 transform data tasks (all filling the same table)

Right click on the Transform Data Task and select...

As Crispin said there are many ways to do this. Here is one.

CREATE TABLE #AppSettings

( SettingCode varchar(4) NOT NULL, SettingValues xml NOT NULL )

INSERT INTO #AppSettings

VALUES ( 'SEC',...

try to use substring instead of left

Just as a note - In sql management studio 2008 (katmai) you could go to: Tools > Options > Scripting > and set the Script for Server version to 2000.

Script out...

Sounds very similar to the process we are trying now.

Our next step will be to create a true "model" database and try some shema compare tool.

The drawback here being...