SAP

This is the option I...

You could also grant VIEW DEFINITION to the dbo schema or any other schemas in the database.

USE [DATABASENAME]

GO

GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO

GO

We use clustering and/or mirroring for SQL 2005 depending on the application. I prefer mirroring since you have 2 copies of the data on separate disks. You have additional cost...

rinu philip (7/17/2008)

I was about to automate a restore process though a job to be scheduled on a daily basis.

But I have a doubt in that, the job would...

If you already have the login created and are adding another db, you can use the proc below to make the user a member of db_owner:

EXEC sp_grantdbaccess ' '

GO

EXEC sp_addrolemember...

I have seen log shipping restore jobs fail when the copy job is still running due to a large log file. A reindex job was the culprit in my case....

Could be a possible permission or domain controller issue. Any additional error messages? Anything in the logs?

Just out of curiosity, why would you not want to take advantage of the Enterprise features and install Standard if you have already paid the money?

Just to add my 2¢, but a checkpoint will not clear the log of a replicated database until the Log Reader has run. If your database is replicated...

Thanks Ken! I guess I read "Number of Users" as "Number of Users Connected to the Database"

Shrinking a database is generally a bad idea unless there is a compelling reason to do so. Are you running out of disk space? Why are you looking to shrink...

I have never seen this number to be accurate in Management Studio. I would be interested in finding out where this figure is pulled from and how often it's updated....

New data will be added to the new data file according to Microsoft's proportional fill algorithm. This means SQL Server will write data to the data file with the most...

You could also have them add another LUN and then you can add a data file to the new LUN. This wouldn't require downtime, like expanding a LUN would.