great article. i have a question though. you say

Length of service shows loyalty."

I am not long out of college, and have been 18 months in a SQL server Admin role...

no trouble at all. what exact error are you getting? i found though that when installing, set up as mixed mode auth, and make sure to enable the sa account so...

Hi. Im still having trouble understanding the contents of the page you supplied. the code:

myServer.sql_endpoint proxy = new myServer.sql_endpoint();

proxy.Credentials = System.Net.CredentialCache.DefaultCredentials;

what kind of object is myServer? what references do i...

found out the issue. i had the server limited to 4 remote connections. youd never know from the above error!!! i would expect the error to say something like "...

crap. just realised the database i question is still on sql server 2000.

so far my solution is this.

I created a job called checkForLogin.

This job runs each minute.

its code is...

a login trigger! brilliant !!! is there a logout trigger also?

no, that was the first thing i checked. we have spread the tempdb out over about 3 drives, and given it 6 files, each 2 gb in size. i could...

Great article! I completely agree. I went to college with 10 friends and we all finished up wtih completely different abilities even when all trained the same way.

One guy...

i had a brief look at lugiment a while ago, but il have a look again. never really done much with it. you would expect a feature like that to...

thanks for that! it seems that point in time restoration is the clostest thing i can get to what i want. it would be a nice feature to be able...

from doing a bit more research i see that i am not using marked transactions. how do i restore to a specific transaction in the transaction log backup?

i already checked that out, but that just shows me how to back up to the last committed transaction in the log backup, and not one of the other previous...

that was exactly what i was looking for. thanks a million. Il do further research now, its just that my question was so simple that i think bol just didnt...

excellent, thanks!

my bad! thanks. yea that helped me out heaps! thanks a mil