Markus this will get you started; this does a first level who's in which role; it does not handle nested roles, where eventually someone in a role, which is assigned...

glad I could help!

i played with making my own macro, but there are just so many variations/things to consider, you really need to do it in a programming language;

what's good for a SELECT...

azdzn (1/13/2012)

---

Lowell (1/13/2012)

---

I wouldn't even try to restore a different server's system databases.

instead, i'd do the following:.

1. script out your jobs in the msdb database,

2. script out the logins...

I wouldn't even try to restore a different server's system databases.

instead, i'd do the following:.

1. script out your jobs in the msdb database,

2. script out the logins with sp_helprevlogin

3....

@Bedrooms is an integer...you have to explicitly convert it when building the string:

'...Bedrooms='+ CONVERT(NVARCHAR,@Bedrooms) + '...'

the openquery says the table starts with an underscore.

MarshAD.dbo._UserSummary works, but MarshAD.dbo.UserSummary fails;

looks like a simple issue to fix then.

i always assumed a visit was the typical web session; 20 minutes of inactivity closes your session (or switching browsers, or closing and reopening?)

i don't see biz.city or biz.state in this definition:

CREATE TABLE [dbo].[shops](

[bizID] [int] IDENTITY(1,1) NOT NULL,

[bizName] [nvarchar](255) NULL,

[bizPhone] [nvarchar](15) NULL,

[bizURL] [nvarchar](500) NULL,

[bizLogo] [nvarchar](max) NULL,

[clicks] [int] NULL,

[clickReset] [datetime] NULL,

[clickTotal] [int] NULL,

[bizActive] [bit]...

"TIMESTAMP" is a very misleading name...it's actual datatype is "ROWVERSION", which gives you an incrementing value to let you know which row was last edited...

if your source is a datetime,...

An exchange server will do a lookup for you to determine that "Joe Smith" is actually j.smith@somedomain.com.

a regualr SMTP server does not do that, it requires a valid email address...

ok, but where is the code running from? SSMS directly, or part of a job? wouldn't a job might be using a...

it might still be a permissions issue, though.

if im a user and only have access to production.dbo.Tables, and no access to the ISCSGSWEBUP01 database (which...

for something similar, we've created the parallel table without the image column, migrated the data, then renamed the old vs new table, and after we were sure everything was beautiful,...

i have a very slight variation of Cadavre's same table; i keep it as a static table, and use it for masking data for testing.