select t.name as tablename, i.*
from sys.indexes i, sys.tables t
where i.object_id = t.object_id
and i.type_desc = 'NONCLUSTERED'
Subscribe to:
Post Comments (Atom)
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists
If you received below error while attaching a .mdf file in cluster environment please follow below steps to resolve the issue ERROR Ca...
-
Problem Cannot drop the user 'dbo'. Rename failed for User 'dbo'. (Microsoft.SqlServer.Smo) Cannot alter the user ... -
If you received below error while attaching a .mdf file in cluster environment please follow below steps to resolve the issue ERROR Ca... -
Microsoft will offer a minimum of 10 years of support for Business, Developer, and Desktop Operating System (consumer or business) Software...
No comments:
Post a Comment