SQLCrazyCertified (5/16/2012)

---

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...

What is the problem you are having with this procedure?

I thought the whole point of allowing the MAXDOP setting in statements is to override what is set at the server level as the options are evaluated at run time...

are the primary and secondary servers the same spec? especially in terms of drive sizes?

what error messages do you get on the copy and restore jobs?

it might just be a...

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...