Thanks. I used exec sp_help table_name..it worked.
No..I am not whats the exact syntax??
All, I am using third party tool WIN SQL to connect to SQL Server Database.I am wondoring is there any SQL command to get table/column definitions...
Moderators.. Thanks a lot for your valuable suggestions.
Its a Trial Version..i don't they will give support on this. If anybody got the same error in past or anybody know whats the cause for that error,...
Two days ago i downloaded toad trial version and installed on my machine to use SQL server database.When i try to connect to SQL Server Database,i am...
Thanks.We can disable and enable indexes on some Database server tables i.e INFORMIX IDS
HI ALL, Is there any way to disable or enable index on sqlserver table instead of drop/recreate index? Thanks, Sriram.
Hi MC_DBA, When I checked using sp_who2 i am getting following output SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch...
Hi, i cancelled execution process n issued drop statement agian,still its running from past half hour. Thanks
Hi ALL, I tried to drop table from database by using query analyser its running forever... Is any clue why i am not anle drop that table. Thanks,...
I would like to clear transaction log files.
HI ALL, How to clear log files in sqlserver database? Thanks, Sriram.
No update trigger on that table. Thanks, Sriram.
Hi ALL, I have a dimension table with identity column(STORE_KEY).When i tried to update that table on column2,its updating the identity column n...
Hi IS THERE ANYWAY I CAN RESTRICT THAT QUERY TO RUN ON MY PRIMARY FILE GROUP? Thanks, SRiram.
HI ALL, WHEN I am querying data using sql statement SELECT Col1,COL2,COl3.. UNION SELECT Cil1,col2,col3.. UNIon ... ... I am getting the following...
Hi ALL, I got a large Data warehouse table with 10 million records, when i am querying that table performance is very slow.So i am planning to...
HOW DO WE KNOW WHERE IS TEMPDB?
Hi ALL, I was trying to run a query on query analyser I am getting following error,eventhough i got 57GB free space on my database. "Could not...
Separate names with a comma.
