I tried both sa and windows authentication login before posting here.. both had the same problem..!

The old database (that doesn't allow me to check its properties) shows the following details for sa login:

UserName UserType ...

How do I...

I have been receiving the same error message all day when I have been trying to execute modified procedure scripts (including create/update SQL jobs) on the SQL Server machine from...

Ok.. so first I backup the log file.. then i use dbcc shrinkfile.. but what size do i shrink it to? how much can it come down from 6GB?

EDIT:

Can I...

Ok! That makes sense! Thanks Suresh!

So that's the way I'm supposed to ALTER a table to set default values to multiple columns then? Especially since I'm looking for a single...

I'm sorry about the topic name typo! I meant DEFAULT CONSTRAINT

Right! Thank you so much!

Which means.. there's no way I can query this table since there's no Datetime field here!

You're right, Iggy.. its not a glitch from what I can see.

I've faced this problem once before so I knew exactly what the question was about.

You can't pass...

Thanks Benjamin!! This seems like the solution I've been looking for!

I'm yet to try it out cuz I need to get my hand on the application and db.. will let...

Msg 15274, Sev 16, State 1, Line 13 : Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000]

Job 'ImportJob' : Step 1,...

Thanks a ton, guys!

In did find the culprit... someone did it through Management Studio.. it was a mistake of course so the developers (who the DB belonged to have decided...

It shows me User as 'N/A' in the Event Viewer!!!

And I just see NULLS everywhere in the log trace!

What am I doing wrong?

Un-delete isn't able to recover anything but the...

I've managed to recover the ldf file using un-delete.. anything I can do with this? I can't get the mdf though..

It has happened through a client and...