Recent content by IT247

ptheriault thx so much for your patience sir i appreciate it. what is the best practice: for the server should i use sql auth or windows (and what account should i use anyways?)

u mean if i change my windows password? i just edited the server regist login to system it asked if i wanted to disconnect when i go back in, i noticed i could not open any login object and right click menu an option is greyed out

well that's part of my confusion i just have two servers showing in EM. The props on the first db says "start and run sql server in the following acct" --- tce\sqlserver (tce is my domain) the 2nd db says tce\mac (mac being my domain user id) so when i open up EM, i don't know what's being used???

did i run it correctly by highlighting and clicking the 'execute query' button on top? does the db have to be on 'master'? all it does is return info for 1 db

sorry but like i said i am just getting started with sql i tried the script i just pasted it into QA, higlighted it and ran it. it output info about one particular db. how do i do it for all? do i need an 'exec' in front of first statement? do i need a 'go' anywhere?

i'll give that a try hey, are u saying that 'sa' is a role? i thought it was just one special user. but where do you set the default login. That is, if i am logged in to with my domain acct, then i open sql (mixed mode auth)will it just go and use my window login? let's say i want to login as a...

how do i do that?

thx P i am having trouble with it. first i created it in master db, ran it and it said it could not find the proc. then i deleted it and created it in my own p7dr db and it said 1)THE table permission table already existed and 2)the proc already exists - as if it didn't really delete it by the...

i'm new to this - what does this code do can i run in sql query analyzer?

sql 2000

hello is there a storedproc that will output the login names and the associated users for each database? thx

thx Mr Denny I read up on the log architecture etc from BOL. I understand it better now. However, I don't see why SQL would create so many vlf's and have just one of them active.

Hello I am not clear about when the log truncation happens. If i do a backup log, does the log truncate automatically or, does it require a switch? right now, i did a dbcc loginfo which shows some 230 vlf's -only one of them is active. I then did backup log and rechecked with dbcc loginfo - no...

Hello I am running one job that runs all of them with this statement in the job step sp_MSForEachDB 'master.dbo.usp_BackupDatabase ?'

aha! i see now thx very much