we created a view in DB1 from the tables from another (DB2) database with in the same instance. both databases having the same owner.we don't want...
the account got locked.
we have a job running in our environment daily in the morning to check for the failed jobs for the past 1 day and will send as a text in the email....
we are getting database mirroring timeout issue when ever our transaction file groows larger.for eg. sunday we will do reindexing and the file size...
we are reindexing only the specific tables not all.And update stats on entire database. Is this a good practice?
does sqlserver 2005 has a feature for encrypting the backups. I read in the searchsqlserver.techtarget.com (topic : SQLSErver backup encryption for...
In all of our production servers, we are having an practice of Reindexing all the tables one in week on sunday and updateing the statistics daily....
is there a way we can set the default trace file that's is created by server from 20 Mb to 1 GB. because the docs you send is for creating the new...
is there a way we can import the sqlserver traces to a table, before it gets rolled off. So that we can maintain a histor of events happen . because...
Your report gives , for resinking the SID. I am not looking for that script.I'll give an example below. servername : dev , prod user : testuser in...
we have a developement server and the prodcution server. The developer has all permissions like create, alter drop..etc.. in developement server.But...
no restore happen.yes i fixed the issue using sp_change_users_login. But want to know how it got deleted?
we had an issue last week like suddenly the user can't login to the datbase.The i chedked , and it's SId is different for that database and the...
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [CLIENT: (ip address)] we are haing an login failure from an user's ipaddress for our sqlserver...
it's the enterprise edition
i am trying to instal sqlserver 2008 in an pc having windows xp. I am getting the error : TITLE: SQL Server Setup failure....
so in the case if we use the same certificate, then we neeed to create a new enpoint with differnt port for the new instance (the port that we use...
trying to add another instance to the principal server
hi, we are having a databaase mirroring enabled on our prod server with the certificates for the datbases on our default instance. and we are going...
what is a proxy account? is it safe to created/model a proxy with the acccount as sysadmin rights? what is the security lying behind the proxy...
Separate names with a comma.
