Viewing 15 posts - 1 through 15 (of 81 total)
Ahmad Osama (2/13/2009)
try login with windows credential
I tried both sa and windows authentication login before posting here.. both had the same problem..!
February 13, 2009 at 2:23 am
The old database (that doesn't allow me to check its properties) shows the following details for sa login:
UserName UserType ...
February 13, 2009 at 12:28 am
May be this is because the database owner has been dropped.....
Try to set the database owner of the referenced database to an existing one..for ex. "sa"
sp_changedbowner 'sa'
How do I...
February 12, 2009 at 11:45 pm
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...
June 27, 2008 at 6:23 am
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...
June 26, 2008 at 10:50 pm
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...
June 17, 2008 at 4:55 am
I'm sorry about the topic name typo! I meant DEFAULT CONSTRAINT 🙁
June 17, 2008 at 4:20 am
Right! Thank you so much!
Which means.. there's no way I can query this table since there's no Datetime field here!
June 17, 2008 at 1:17 am
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...
May 19, 2008 at 10:37 pm
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...
April 23, 2008 at 11:18 pm
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,...
March 31, 2008 at 12:46 am
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...
March 28, 2008 at 5:14 am
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...
March 26, 2008 at 5:05 am
I've managed to recover the ldf file using un-delete.. anything I can do with this? I can't get the mdf though..
March 26, 2008 at 3:46 am
Buxton69 (3/26/2008)
Do the users have to go onto a server (RDC etc) to access the databases or do they do it through a client?
It has happened through a client and...
March 26, 2008 at 3:44 am
Viewing 15 posts - 1 through 15 (of 81 total)