To properly assist you with tested T-SQL please post table definition(s), sample data and desired results.

To do so please click on the first link in my signature block for a...

Try this

Instead of changing the execution time-out through Tools -> Options you should be able to specify it when opening the first query/connection to a SQL Server in the "Connect...

What method are you utilizing to attempt to import the file SSIS or OPENROWSET or BCP?

Not knowing that, but here are some ideas which might spark your thinking.

1. ...

Have you considered creating a VIEW which would contain only those records that could be edited?

Try this T-SQL

SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%deprecated%')

and/or read this:

http://msdn.microsoft.com/en-us/library/ms186265.aspx

To better understand the space taken by indexes, and thier usefulness in finding data in a table may I suggest your read this article:

http://www.simple-talk.com/sql/performance/lipoaspiration-in-your-sql-server-database/?utm_source=simpletalk&utm_medium=email-main&utm_content=Lipaspiration-20110307&utm_campaign=SQL

If by "data space" you mean the...

tilew-948340 (3/15/2011)

bitbucket-25253 (3/15/2011)

As we all do ... let me challenge you .. submit a good QOD, you will be surprised at what you learn, quote]

Submit a QOD, even a bad...

now you have me completely confused as to what it is you need ..

Sample of the log file with the info in my previous post

(Order,Point Name,Duration) with R1:

1 Point2...

tilew-948340

But it does not realy matter anyway because the reason for the "question of the day" is not the points but the fun of learning... I learned something, so I...

yes each value is unique wether it is defined as a primary key, index or whatever.

Before making the change that the customer is requesting.

As an IDENTITY the each value is unique.

1. What would be the possible adverse effects if duplicate values are...

This undocumented procedure (spMSforeachtable) might be what you need.

http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm

http://weblogs.asp.net/nunogomes/archive/2008/08/19/sql-server-undocumented-stored-procedure-sp-msforeachtable.aspx

Thank you, for letting all who answered know that you have been helped. It is appreciated.

Here we go again -- the specified as correct answer is an item to be depreciated in a future release of SQL Server and one possible answer, and the one...

tilew-948340 Posted Today @ 8:51 PM

I gues I just had to not take a chance and do not answer it, but for the futur, if at least we don't loose...