kumarreddy72 (10/12/2011)

---

Thanks for the Great Info 🙂

I resolved my issue by recreating the Index.

However the above query which you have written is not working. it is not returning...

DECLARE @sql varchar(max)

SET @sql = (

SELECT 'SELECT ' + QUOTENAME(QUOTENAME(TABLE_SCHEMA) + + '.' + QUOTENAME(table_name),'''') +

', * FROM ' + QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(table_name) + ' WHERE CompanyId...

Sound ok.

You're not using the instance in a production environment, so it should be ok.

This extracts the indexes that depend on the column.

SELECT A.name

FROM sys.indexes AS A

INNER JOIN sys.index_columns AS B

ON A.object_id = B.object_id

AND A.index_id = B.index_id

INNER JOIN sys.tables AS T

ON T.object_id =...

You're welcome.

Glad I could help

In order to change the collation (or any other property) of a column, all dependant objects must be detached.

This means indexes, defaults and the like must be dropped and recreated.

Hope...

Use a CASE expression in the ORDER BY clause.

DECLARE @Locations TABLE (

LocationName varchar(10)

)

INSERT INTO @Locations VALUES('Africa')

INSERT INTO @Locations VALUES('ASIA')

INSERT INTO @Locations VALUES('America')

INSERT INTO @Locations VALUES('Europa')

SELECT *

FROM @Locations

ORDER BY CASE LocationName...

Yes, you can.

If you can't log in, you can't run commands, even from SQLCMD.

You could use the DAC (see here for details) to connect as sysadmin and then change the default DB...

You could issue

SELECT text

FROM sys.dm_exec_requests

CROSS APPLY sys.dm_exec_sql_text(sql_handle)

WHERE session_id = [SPID causing trouble]

to find out what command the session is running.

Or, even better, you could download and run sp_WhoIsActive by Adam...

Check the original post and you'll find my answer.

Regards

Gianluca

You didn't give much detail of your issue, but I guess this should do the trick.

DECLARE @A TABLE (

id int,

modifier char(1)

)

INSERT INTO @A VALUES (1, 'a')

INSERT INTO @A VALUES...

You're welcome.

Glad I could help.

As I said in my previous post, I don't see a batch file as a the right tool for this job.

However, you could redirect the output of SQLCMD to an...

You could capture network related wait stats for a single query using extended events.

Paul Randal has a very nice example here: http://sqlskills.com/BLOGS/PAUL/post/Capturing-wait-stats-for-a-single-operation.aspx

Hope this helps

Gianluca