Dennis

.mdf and .ldf files are not backup files, they are native SQL Server database and log files respectively. All you need to do is copy the files to your standard...

OK - so what is the relationship between T1 and T2? Do you just want them displayed side-by-side in ascending order?

Please describe how to get from your sample data to your required results. Where did the 100 and 200 come from?

I don't think so. You'll have to change your logic to move your DBCC statement out of the transaction somehow.

Not sure. Could you do something like

osql /L > sqlservers.txt

to redirect the output to a file called sqlservers.txt and then use that in your app?

SQL 200 - that must have been a while ago

Have you tried installing EM on another PC and seeing whether it happens there...

What is your question?

Creating and deleting tables uses resources, of course, and this is an unusual way of designing an application.

Whether this starts to cause you performance problems depends on volumes, hardware, how...

Well, I guess you could try this.

First off, replace all of the single quotes with something else - eg ~ or some other character that does not exist elsewhere in...

The single quotes will cause all sorts of problems, that's for sure! If you already have an ASP page that does (or should do) this, it will probably handle the...

Ace.

What's the datatype of the content field?

It's best if you specify the fields that you are INSERTing into - also use single quotes and dump the curly brackets:

INSERT INTO FamousFacesSubmissions (StoryID, SubscriberID, DateSubmitted)

VALUES (newid()

OK, I know what this is. The ID will have a data type of 'uniqueidentifier', probably with a default value of newid(). SQL Server will generate this for you on...

So the question is: "What generates the SubmissionID code?"

If it's a SQL Server IDENTITY field, you can try the INSERT statement I gave you, but without the SubmissionID, ie

Try inserting the row without the CONTENT and SELECTED fields first. If it works, we'll move on to CONTENT.

INSERT INTO mytable (SubmissionID, StoryID, SubscriberID, DateSubmitted)

VALUES (p1, p2 ,p3 ,GetDate())

and...