But we...

Thanks,

It's clear that we must need to create login in order to create a user.

But Is that must to create a user on Primary production Database, in order to access...

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

Then how a user can query that standby mode database? Because log shipping says, users can query the database if we...

Thanks for the information

I have created a schema in SQL Server 2008 and some tables, views and procedures in that schema and able to see that schema in Security folder.

But unable to see...

Geoff,

Do you have similar kind of script to notify when blocking occurs?

We are experiencing blocking and do not have script to notify. please advice..Thanks

I got the results:

we just need to change the below in your query:

select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like...

I ran the below code, but got NO results

IF OBJECT_ID('tempdb.dbo.ErrorLog') IS Not Null

BEGIN

DROP TABLE tempdb.dbo.ErrorLog

END

CREATE TABLE tempdb.dbo.ErrorLog (Id int IDENTITY (1, 1) NOT NULL,

logdate DATETIME, procInfo...

I followed the steps discussed in...

Perhaps you want to explain what you are trying to do in the database from a logical perspective, rather than saying you want a login to own a schema. What...

So in either way login has be created right?

and what permissions need to be given to the login to create objects in that particular schema?

Lets say, I have created a...

Thanks. I need to create 2 schemas for 2 users, for example Matt and scott naming the schemas as Matt and scott and then allow them to create their own...

The backup drive is clustered file share and I created the share as BizBackups and the path is Z:\BizBackups.

But in the backup path, I have given it as \\sqlvs2\BizBackups so...

But the backup job is running fine for the next run running at 10:30 PM (The backup job runs every 30 mins. Full backup at 10 PM and log backup...