Hi Satya, Thank You Very Much. The first link, which you provided, resolved my issue. Thanks & Regards, N.Babu Don't try to do different...
Hi, I receive this error message in one of my servers : "Failed to reserve contiguous memory of size = 131056." I have enabled AWE memory on this...
Hi, I am purging a database and to carry out this activity the database needs to be in single_user mode. The Log size of the database filled up....
Hi, Regarding Red-Gate SQL Backup, the compression ratio is really good. I have a database of backup file size more than 225 GB (Normal SQL Backup)....
Hi, This is a Production database and the size is about 32 GB. Could you please let me know whether it is possible to delete a row in sysprocesses...
Hi, Could someone let me know how to delete a row from the "sysprocesses" table. Thanks & Regards, N.Babu Don't try to do different things;...
HI, I tried to restore the database from Backup too. However, it didnot work and I was unable to detach the database either. In the sysprocesses...
Hi , I changed a database to Single_user mode. I executed some commands and I tried to kill a process and it is taking a long time. So, I restarted...
I looked into the Link and I followed the Workaround mentioned over there. The problem was sorted out. Thank You Very Much Thomas. Thanks &...
No, these jobs run at different time. I checked out the maintenance plan history. It says that the problem is with the configuration of...
Hi, I have a database of size around 7 GB. I created a maintenance plan which backups the database and also updates the statistics in the database....
Hi, Yes, we are processing huge number of rows in that particular job.We scheduled it in smaller batches and now the sp gets executed within 30-45...
Hi, In my appliaction, I have a stored procedure which calls 11 different stored proceudres within it (all in a single batch). That is causing...
Hi,<br /><br /><br />I tried the above option in the PUBS database. However,there is no concurrent transaction at that point of time in PUBS. So, I...
Hi, Once you run DBCC UPDATEUSAGE,it corrects the inaccuracies in the sysindexes table. sp_spaceused makes use of the sysindexes table regarding the...
Hi DBA_Ashfaq, Please let me know how you resolved this problem. Because, I believe in SQL Server 2005, we cannot move the Log data from one file to...
Hi, In addition to what Satya said, You can run sp_help_revlogin script in the source server and then copy the scripts in the test server and run it...
Hi, Create a database with .mdf & .ldf files. Then restore the database from the backup using WITH RECOVERY option. In your scenario, I feel, the...
Thanks for your replies. My doubt got cleared. Thanks & Regards, N.Babu Don't try to do different things; Do things differently.
Hi, I have 1000 records in one table with a clustered index on one column( for convinience let's take it as eno). Now, I want to insert a record...
Separate names with a comma.
