is there an option to select/deselect in SQL Server Agent in the installer (I dont remember)? If so, you can add components. If not, I wonder how youavoided installing the...

if both the servers are standalone ( I mean not part of any domain), create a local login on both the servers, say "SvcSQL" with the same password. Add these...

when you access the network dive from start--> run --"location", you are using your windows credentials with which you logged in, to access the location. When you run backup to...

check backupjobhistory in msdb to find some clue

Got resolved?

search for .bkf files

Thabks for a good article. In my previous company, I used to handle near about 300 db servers with data aggregate to 13+TB. I was assigned o build the production...

open SSMS --> Databases (click the righ button of your mouse) --> tasks --> Generate Scripts.

This will open the wizard. Select your database and click next. In the script options,...

you can use the blog. Revert back if you have any difficulties.

http://rajanjohn.blogspot.com/2008/04/using-database-mail-in-sql-server-2005.html

go to ssms and use the generate script for database. In the wizard, initially you can selet what all objects you want to script In the further steps you will...

what is the isolation level your application is using? you saw these deadlocks only this time, or are you seeing frequently? do you normally do index maintenances?

I think you can ask your Network Administrator to create an alias for your server name as "project name". thus, any call to http://project_name will resolve to the web server...

you can use CASE with conditions.

If the growth is a GB per 6 months, you should not be using the autogrow at all, add 3 or 4 of GBs for an year and sit back!...

rather than forcing the changes manually by us, do we know how sql server internally makes the changes, and how frequently, which component is responsibke for the changes?