Viewing 15 posts - 8,341 through 8,355 (of 9,244 total)
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'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 4:10 pm
xgcmcbain (3/11/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 3:13 pm
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....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 12:56 pm
hey, your welcome buddy 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 2:17 am
i think the windows registry would be the best place to look
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:34 pm
try running it once a week during a known period of low or no activity!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:32 pm
GSquared (3/10/2009)
stuck with going back to your last full backup,
or differential if you have them.
Simple recovery logs just about the same as Full recovery although some transactions are minimally...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:16 pm
what is the error you are seeing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:09 pm
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 12:39 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 12:09 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 3:42 pm
i had a telephone interview last week for a job and the interviewer asked me to provide port numbers for some commonly used TCP ports (e.g. DNS, SQL, POP3,etc). If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 1:40 pm
GilaMonster (3/8/2009)
Perry Whittle (3/8/2009)
also depends on if they mean client or server side. Server process is sqlservr.exe
Server or client, how important is it really for a candidate to know that?...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 1:32 pm
also depends on if they mean client or server side. Server process is sqlservr.exe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 11:33 am
Jeff Moden (3/8/2009)
And there is no "run SQL Server faster" button
aww shuks, i been lookin for that one LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 11:29 am
Viewing 15 posts - 8,341 through 8,355 (of 9,244 total)