you didnt get the job then?

full filegroup backup is different to full database backup

Ryan Wellman (5/16/2007)

---

Sweet!

I changed the "log on as" to .\Administrator for SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER). In the SQL Server Configuration Manager and ran the Log...

the application will generally just issue statements to the database. What can cause problems is 32 bit versions of sql server interracting with 64 bit versions, replication in particular is...

Dave (3/10/2009)

---

I am trying to locate some sort of information to present to my managers regarding whether there is any differences, between 32Bit and 64Bit, in the way SQL Server...

if the server login exists and the database user exists in the database you only need to use

exec sp_change_users_login 'Update_One', 'Current user in DB', 'SQL login to link to'

xgcmcbain (3/11/2009)

---

2) by limiting my ram, am i hurting my server in anyway? Now remember, in my environment none of my select statments are redundant so cachine a queiry...

queries are only a small part of what sits in RAM, you have the buffer pool too which comprises all the database pages read from disk to memory for modifying....

hey, your welcome buddy 😉

i think the windows registry would be the best place to look

try running it once a week during a known period of low or no activity!!

or differential if you have them.

Simple recovery logs just about the same as Full recovery although some transactions are minimally...

what is the error you are seeing?

in Profiler select the "Audit Shema Object Access Event" and filter it to look for your database name and object name (this should match the name of the table)

the following should generate the alter schema commands to change schema for any Stored Proc not owned by dbo

select 'alter schema dbo transfer ' + sch.name + '.' + tab.name

from...

if a manager asks you to setup Perfmon to monitor sql server processes and uses (especially on a multi instance box) he wouldnt expect you to say " yeah i'll...