Hi Friends, I am new to SQL Server Administration. I have created the Daily Maintenance plan as below and the Rebuild Index task fails once in a week. Backup...
Noticed that everyday my Maintenance Plan log is empty as below even all the tasks Succeeded. The Maintenance Plan has the following tasks Backup Database Task...
Hi We requires that unsuccessful and successful login attempts be logged With the excessive log files now being created is it recommended/approved to only...
Hello , The Concept is great, We Learn, Earn and have Fun same time & Its FREE. No buying/selling, the website earns from advertisers and sharing profit with...
I have a database with different schemas, and I was asked to restore only DBO schema from the lightspeed backup file. Is there any way to restore a single...
Hi,   I changed the “page_verify_option” set to CHECKSUM in production server.  My DR database “SAP” is in "Restoring" does this stop the setting...
Hello , When Google, Facebook and Twitter was launched, no one thought that it will become our necessity, I come to know a very interesting and innovative...
In my environment Login Auditing is currently set to "Failed Logins Only" This is probably a carry over from the old servers were it caused excessive log...
Hi, I need to set Password to expire in 80 days in SQL 2005. Can anyone help to tell me how should i do it. I think i also need to change the windows...
Hi All, Here a i have a problem with in Database mirroring environment. I have a huge unsent log in Asynchronous (high Performance mode) Its current...
Usage of operators The speed of the query also depends on the operators used in the where clause. Key operators used in the WHERE clause, ordered by their...
Very interesting article by ASP.NET MVP Hima on Connection Pooling. Connection Pooling is the ability to reuse the database connection for more than one user....
Hi sqlcon@yahoogroups.com, I set up a Facebook profile where I can post my pictures, videos and events and I want to add you as a friend so you can see it....
Hi all, I am facing an issue on sql server 2000 with sql agent job history. below are the details Box- Windows 200 server Sql server 2000 with sql4 Only one...
Friends, Adobe Systems, Noida - Requires MSSQL DBA with around 5 years of experience. Profile: Infrastructure DBA (experience in Database infrastructure...
Hi, I am a newbie in this field (MS SQL) and would like to meet people in Hyderabad which provides me a great leraning opportunity. Can anyone please let me...
how to execute DTS package from stored procedure .. and i tried the follwing syntax EXEC master..xp_cmdshell "DTSRUN /S bng-silver13 /U sa /P sa /N New...
Hello, SiliconIndia is organizing an exciting event on May 29 & 30, 2010 in Bangalore. I had attended the last year event. This is something one shouldn't...
Hi All, We have several open positions on Silverlight 4.0, WCF RIA Services, .NET development (ASP.NET and Windows Forms) and SharePoint 2010. Please little...
Hi i joined this group few days ago. actually i was very desparate to join it . i had impression that this is a group of MVPs and Sql experts, and i was ...
Dear All, We have a running sql 2000 active/passive cluster on windows 2003. Now we want to add 2 disk array. Can any one please help me with the steps to do...
