Viewing 15 posts - 1,066 through 1,080 (of 1,335 total)
your DBCC should get logged by default by not all information will be available. I hope you can turn on c2 logging which is a costlier operation to audit all...
June 20, 2007 at 4:41 am
check for permission on sql registry keys and default installation paths. That might have caused the access issue.
June 20, 2007 at 4:37 am
check for permission on sql registry keys and default installation paths. That might have caused the access issue.
June 20, 2007 at 4:34 am
What does those job DM_CHECK_ERROR/OK do. Does it call a stored procedure or any TSQL code.
June 20, 2007 at 4:31 am
What Jeff says is right. Altering collation after creation creating the database only changes the collation of the database any objects that would have been created will have the collation...
June 20, 2007 at 4:31 am
First the osql command requires SQL Server user id and password and I did not want to put in the bat file because it is not secure
You have the option...
June 20, 2007 at 4:13 am
When you say your main database, if its master you have to rebuild then add your logins. etc, etc and then bring up the server. Else if its going to...
June 20, 2007 at 4:10 am
Cat,
This is what i told before i just said the way to get it and you haev coded. Great. hats off Buddy.
June 20, 2007 at 4:03 am
Is it that you have your web application deployed in the same machine where your sql server is also running. Check for the remote connections properties in the instance and...
June 20, 2007 at 3:58 am
Knight, Make the developers and Management understand that SPs are faster than D-SQLs. Say them the pros and cons for each i am pretty sure that they will go for...
June 20, 2007 at 3:40 am
You want to set it to unrestricted growth. After you hit ok you have unrestricted growth. Then whats the problem. Do you mean to say that you need to set...
June 20, 2007 at 1:47 am
The following side-by-side conditions are not supported in this release:
June 20, 2007 at 1:31 am
Few question from me.
1. Why do you want to add a role inside a role. You can directly give permissions to the role itself instead of giving to other role...
June 20, 2007 at 1:22 am
It does not necessarily need SYSADMIN permissions but it needs permissions that are very particular and if your jobs access resources better to run the service in a domain account....
June 20, 2007 at 12:10 am
This particular SPID is for your agent to run. Whenever you start your agent in SQL Server it makes a connection to the server with the program naem SQL generic...
June 19, 2007 at 10:58 pm
Viewing 15 posts - 1,066 through 1,080 (of 1,335 total)