george sibbald (1/21/2014)

---

well - sysadmin - no only joking, don't do that 🙂

that script will add the user to model as well, so all new databases would automatically get the...

Any help, please?

Thanks

Thanks, you are right I mean DML, one update, one insert,

it looks like using a temp table is a good solution.

Thanks,

Lowell (1/8/2014)

---

yeah, i didn't see a value in it either;

the grant for GRANT VIEW ANY DEFINITION TO AppInsightUser

lets the login see the metadata without having to be a user int...

Thanks, I cannot find any information on line about Public role has connect permission to a database.

Could you provide a link that tells public role has connect permission.

What I understand...

So does it have connect permissions?

If not, how this works, the vendor's script grant the service account to each database without specifically add any other permissions, but they said this...

Thanks, it adds it to each database, but didn't grant any permission,

But I guess it defaults to connect permission, that is just what the vendor product needs

In your backup example, the "." means "the current folder as specified by the preceding statement (BACKUP command)", ie the default backup folder, followed by a single backslash. If...

Thanks, tried...

Divine Flame (12/6/2013)

---

If you only write the backup file name & DO NOT provide the backup directory path, then SQL Server automatically takes the backup in default backup location.

BACKUP DATABASE...

Thanks, let me redescribe some of the info. Note I deleted the copied over backup files from production to test after restore.

We do backup on both test server and production.

After...

Thanks, will do

Thanks,

So for the first top 2 records, can we see it is a hardware problem or not?

Thanks much, Jeff.

Could you tell me where you can see it could be issue with memory module 3 or 4 in the attachment?

Oh, I see - I accidently highligted...