Hi All, When am restoring the database in sql server 2005 am getting the error message. The file "File name" is compressed but does not reside in a read-only...
Hot Jobs-Noida /Gurgaon /Chennai /Bangalore One of the largest IT company of India is hiring the following professionals * Remedy Professionals -Noida [L2 / L3...
Hi Team, I don't have last 6 months backup with me.I did not track the growth of the databases for last six months. My manager asked me "Find out the DataBase...
I hope you have backup policy in place. If the growth of DB is the issue , then you must check what is the recovery model and what is the backup policy....
Hi All, There is a UG event on Katmai/SQL Server 2008 on 15th of Dec at Microsoft Campus between 4.00 P.M to 6.30 P.M Interested please register here... ...
1.You dont need the backup, but if you had a backup the info will be in Backupset table select backup_set_id, backup_finish_date, name from msdb..backupset ...
i wrote a script to audit the users/roles access to the tables. i have achieved it for users who are not in any roles. But for the users who are added to roles...
Hi All, what is the equivalent command for the "xp_restore_filelistonly" in sql server. "xp_restore_filelistonly " this command is litespeed command to know...
In SQL Server, we use this RESTORE FILELISTONLY FROM < backup_device > For more info about this command, See BOL. Rizwan.... Shyam Sunder <shyam_k25@...>...
Hi All, I have a long running procedure (batch job) which will take quite some time to complete. I need to run a fixed number (configurable value) of copies...
Hi All, I have created one job in SQL 2005 server. Now i want to schedule it to start and stop. For an instance it should start at 9:00 and stop at 18:00. Can...
In Job Schedule Properties tab, Set the "Frequency" as Daily, Recurs Every: 1 Days. Below that, "Daily Frequency" Select "Occurs Every", set 24 Hours, Starting...
I will be out of the office starting 14 Dec 2007 and will not return until 2 Jan 2008. For any urgent matter please contact Sushant WAGLE/ITD GLT/HSDI/HSBC ......
Dear Babu, I have one question on your stored proc for paging. if am fetching a result set of say 10,0000. how much time it will talk to store in the temp...
Hope you have checked the right code (in my example, first one is before tuning and second is after tuning). Consider I'm in 3rd Page, so @PageNo=3, and...
Hi Deepak, Sorry, so far I have no clues on this. Any way I'm discussing this with my friends, and if anything come across, I shall let you know. Regards Babu...
Hi All, I am involved in performance audit of my sql servers(2005), i got stuck on below points: 1.) Are there any indexes that are not being used in queries?...
I want to prepare an patch update. For that i want to stop users to access the database and the application. Since users will be maintained in different...
Make sure the down time is available for updating patch in server.First open query analyzer---->Next run sp_who2----------->after geting user permission kill...
Hi, We have requirements for Database Developers (at various levels). Minimum 3 Years experience with atleast 1 year in SQL Server 2005. Organisation : Excel...
Hi Group We are looking for SQL Professional having expereice in following area. SQL Server Developemt and SQL Server Administration. Experience - 3 + Company:...
Use Master Alter Database YourDatabaseName Set Single_User With RollBack Immediate read about this in BOL for more info Madhu ... to access the database and...
Hi Plz post the mails regarding VISA filing under 2008 quota. Thanks Chandra gethari_tng <haribabutest@...> wrote: All INTERVIEWS IN INDIA ARE AT U R...
Enter your vote today! A new poll has been created for the sqlcon group: Quiz! What is the quickest way to copy a table from one database to another? o SELECT...
sqlcon@yahoogroups.com
Dec 24, 2007 12:42 pm
5921
Hi all, I have a database in SQl server 2000.suddenly it went to suspect mode. I dettached database but while attaching i am getting error 'unable redo on...
you can set the database in to emergency mode by updating its status field in sysdatabases table in master database. so that database can be read. create new...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
