Viewing 15 posts - 28,471 through 28,485 (of 49,552 total)
R2 is a new version, you will need to purchase new licences.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 4:01 pm
gmamata7 (1/13/2011)
But we do not want to create these users in Source production instance.
In log shipping, the secondary is an exact copy of primary (at the point of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 3:59 pm
Existing users can query the log shipping secondary.
You cannot create new users in the secondary because that's a change and the database is read-only (no changes permitted)
You can create the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 2:58 pm
Is autoshrink on? Are you shrinking the DB manually?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 1:49 pm
Restore the backup WITH NORECOVERY. Then you can restore additional log backups, when you have restored the last log backup that you need to, run the command to recover the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 1:14 pm
Why don't you just define id_pc as an identity column?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 11:08 am
SELECT @@version. It'll say x86 or x64
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 8:53 am
You can't put a SET inside a query.
Try SELECT @ROW_NUM = @ROW_NUM + 1 as row_num, but no guarantees that it will do what you want
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 8:52 am
The clustered index is the table.
When you have a table without a clustered index it's called a heap and it will appear as index_id = 0. When you put a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 7:55 am
naveenkumar_segu (1/13/2011)
If both do the same job, why two then?
They don't do the same job. They do completely opposite things.
Let's say we have a database with three tables in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 4:07 am
naveenkumar_segu (1/13/2011)
db_datareader -> grants select permissions and doesn't allow you to update anything in the tables (means denying insert, update and delete permissions)
db_datareader doesn't deny you insert, update, delete permissions....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 3:57 am
Koen (da-zero) (1/13/2011)
Or do you deny access first to everyone and then give specific access to some resources?
That won't work. Deny takes precedence over grant.
So if you make everyone a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 3:53 am
What exactly do you need to do? You do not need sysadmin just to script tables out. View definition rights to the schema is adequate.
Leave the system objects alone, they're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 3:20 am
One grants select permissions on all tables
One denies insert, update and delete permissions on all tables
This should be explained in Books Online. Did you check there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 3:19 am
Call Microsoft customer support and log a case. Just make sure you're on the highest service pack first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2011 at 3:11 am
Viewing 15 posts - 28,471 through 28,485 (of 49,552 total)