That part is easy then -   Run the script.

The script is just plain TSQL used for re-creating the object.  It can be opened in SSMS or SQLCMD and run against...

If you want the data as well as the table, that method won't work.  If you ONLY want the table schema and don't care about the data, that will work...

There are multiple ways, but I like the "don't reinvent the wheel" approach.

Get a SQL Monitoring solution in place.  It will tell you about blocking, deadlocks, long running queries, etc...

I think it is one of those "it depends" questions.  Is it going to be used ONLY for development purposes only (ie no production data, no UAT, etc)?  Then there...

SQL Server only captures the data you give it.  So if you have no method of checking when data was inserted (modified date column for example), then you would need...

Glad I could help!

Adding clustered indexes is never a bad idea (you can have 1 per table), as long as your clustered index is on the correct column(s).  The ideal...

I just noticed my "UNICODE" examples got screwed up.

As for SheilaMajors's response about "LONG TEXT" and "MEMO", those are not valid SQL Server data types that I am aware of. ...

WHERE <date column> >= DATEADD(day,-7,GETDATE()) AND <date column> <= GETDATE()

Mind you, you may need to do some tweaking to those to make sure you are getting the EXACT...

You are right there The Dixie Flatline... the ROLLBACK rolls back all transactions.

Not sure why I thought it only did the most recent one.

COMMITs happen per transaction though.  So if...

Unicode is basically special characters OR non-english characters.  If it is all characters you can see on your keyboard and you have a USA keyboard layout, then you likely don't...

One way (not ideal) to do it would be to have the excel have the "corrected" data in worksheet 1.  Worksheet 2 has a connection to SQL and pulls in...

I think it really depends on the requirements, the source data, and the expected output.

What I mean is if you are asking for 1 date parameter and then it uses...

If the max length is 450 characters, VARCHAR(MAX) is going to be overkill.  Even VARCHAR(1000) would be overkill, but would give you wiggle room.  But it depends too.  If your...

What is in your SQL error log (ie not the windows error log)?

My guess (without seeing your system and seeing ONLY what you posted) is that there is some sort...

One thing to note about Paige031's comment is that if you use the + operator on a VARCHAR and an INT column and the VARCHAR cannot be converted to INT,...