The question you have to ask is this, if the database runs your application, should the clients be updating your application database? What if they drop a table which...

SQLCrazyCertified (5/16/2012)

---

jitendra.padhiyar (5/15/2012)

---

Hello Masters,

During upgradation, all the user database will be upgraded to new version, but what will happen to system databases?

When you install newer version, system databases comes with...

How do you currently back up your databases?

All you need to do...

Stewart "Arturius" Campbell (5/16/2012)

---

The MAXDOP only overrides the configuration option for index operations once the index has been created. The actual Index operation (plan execution) will use more processors as...

This URL will help you understand DELCARE http://msdn.microsoft.com/en-us/library/ms188927.aspx

You will need to do something like this

DECLARE @column1 somedatatype, @column2 somedatetype, @column3 somedatatype

I have just tested this against my test user limiting permissions to db_datareader only and they cannot export the scripts. They can get all the way through the wizard...

you need to declare the variables @columnNames and @columnConvert, take a look at the DECLARE syntax and then define the correct data type which is needed for the variables.

do you want compression on all backups, full, diff, tx log? if so just set the compression on as standard at the server level. otherwise simply add WITH...

then you need to look at the running totals method which Jeff has detailed in his post.

This is down to the scope and inheritance, as you granted the permissions at the database level not the procedure level, so you wont see it at the lowel level...

Not a problem, that got me out of a number of holes where our Junior DBA issued a modify file which had a space at the beginning of the file...

what about with the /f switch which should just start the MASTER database to which you should then be able to execute the alter database statements

http://msdn.microsoft.com/en-us/library/ms345408%28v=SQL.100%29.aspx

I would also look at your drive configuration after it and see if your current config / RAID levels are sufficient enough to support failure of hardware to hopefully mitigate...

I think you would have to start SQL in single_user or minimal config mode and then issue a number of alter database commands to alter where it thinks TempDB lives...

Again, personal preference.

In the example you have given below, within BIDS (business intelligence development studio/visual studio) you have the option to right click a task and run it on its...