Tnx for the reply Gquared and Earl,

But the table i posted is what i would call an "end table", by witch i mean, its a collection of information thats frequently...

Hi, little question here..

I believe that database snapshotting is only avail in Enterprise edition (correct.?)

So if we setup mirroring on a standard edition, that would mean that the standby (mirrordb)...

I'm pretty sure the per processor license is cheaper,

we also have a 60 user situation and therefore have made the calculation.

If you buy the per processor license you only have...

Or you could use:

SQLToolbelt from Redgate

oes allow you to make : database schema differences between 2 databases (or even backups)

and permits you to see the real datadifferences in 2 databases

you...

Sandy,

You can see users idd on each database where they have rights to,

You wil see the SQLServer users and the WindowsUser if any,

Or you can even see Windows User Groups...

Hello Michael,

Tnx for the reply,

The code works perfect !!

Now a little question for performance issues,

We would love to create a view based on this select statement,

Both tables have around 20.000...

Tnx Gail,

Just what i needed to know,

The ghost backup is for system disaster recovery,

Database backups are not with ghost,

I use Red gate SqlBackup for this. + from time to...

hi mobasha,

tnx for the reply, it was just to make sure.

the other system databases (temp - model- msdb) does the need for a backup exsists here also.?

For disaster recovery do...

Hi,

This question bugs me a little bit, If i understand it correct then the users are placed in the user databases but the logins (eg windows groups) are stored in...

Hello Marios,

The script that you provided here, what exactly should i make up of it.?

We are just starting sqlserver development so i do not yet have a lote of users...

Hello Jeff,

Thats not an issue,

Its the idea of (from application development view)

To have a easy way of copying a record, (inserting into the database)

Get the id of the new inserted...

Hello Andras,

Idd, the routine you provided does what i wanted it to do,

except i do not get the new id for the identity columns

it executes the insert but doen not...

Hello

No, its not for retrieving of data,

But for some application elements it would be very handy to copy a complete row of data

and then alter some values of...

Hello tony,

Can i include (or create) views based on functions .??

I already noticed that the possibility of including stored procedures is not possible...

Chriss, tnx for the tip on the left...

Hello Tony,

I find your code much easier to read and maintain but have some questions about it,

If you enclose the select into a max( ) statement, can the query optimalizer...