Viewing 13 posts - 16 through 28 (of 28 total)
I have a requirement to know what databases are being used in DTS packages. Is there any way to do this?
For example a given Database X, is there any...
October 29, 2008 at 10:15 pm
There is nothing as view taskpad in the EM which i can see.
October 17, 2008 at 1:04 am
Hello,
Am using 2k. Do you mean that if i do a back log, space will be regained?
Thanks
Akb
October 17, 2008 at 12:47 am
I want to know whether an index found on the linked server is clustered or not. i may be wrong but I believe indexproperty wont work here. Is there any...
October 14, 2008 at 4:13 am
There is no transaction logs backup running. Is there any script to complete the same? Because i had scheduled this index defrag. I can complete the transaction log back up...
October 14, 2008 at 4:08 am
please refer to this link. It might be helpful:
http://qa.sqlservercentral.com/articles/Test+Data/61572/
Also refer
October 14, 2008 at 2:28 am
HI Gail,
The recovery model is full. I hope this help.
Thanks
October 14, 2008 at 2:23 am
The data has not grown by much. May be only a few rows only. I need to regain this space for other db on the server. Is there any way...
October 13, 2008 at 3:55 am
What has grown exactly? Is it data or only the log file??
Is there any way to gain back the space..?
October 13, 2008 at 2:29 am
create procedure proc1 (@i int)
as
declare @sql varchar(1000)
select @sql="select field"+@i" from "
exec (@sql)
go
I havent tested the procedure myself. I hope you get an idea.
Cheers
Amit
October 7, 2008 at 2:10 am
Hi Friends,
I badly need help on this. If you have any replies, please do post.
Thanks
Amit
October 1, 2008 at 10:22 pm
Hi There,
I have run the dbcc updateusage but nothing changed. My question though is that what makes the size of the database so large.
I run a sp_spaceused, the results are...
September 30, 2008 at 5:15 am
Hi
Thanks for your reply. I did check for alter statement, but nothing is there. The stored procedure does not alter anything but ,it does, insert thousands of records to...
August 27, 2008 at 3:15 am
Viewing 13 posts - 16 through 28 (of 28 total)