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...
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...
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 import the sqlserver traces to a table, before it gets rolled off. So that we can maintain a histor of events happen . because...
we have a developement server and the prodcution server. The developer has all permissions like create, alter drop..etc.. in developement server.But...
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...
i am trying to instal sqlserver 2008 in an pc having windows xp. I am getting the error : TITLE: SQL Server Setup failure....
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...
there is a job calling the dts packge.a developer setup this job and dts and he doesn'r work here anymore. So i need to delete and recreate the...
as a part of security , i am planning to create an user for running the jobs. we are having backup jobs, restore jobs,ssis package job,reindexing...
one of the user (domain account) in the database belongs to the sysadmin role, but he is not able to look into any of the jobs.. i have no idea why,...
what kind of jobs the guest could create..if the guest account is in the sqlserver agent user role. i know that they can create,modify and delte the...
In our production sqlserver, there is an application running that needs to have guest account needs to have access to msdb database..is there any...
i installed management studio from sqlrun_tools.msi file in the windows server...will it count for license
i need to install the sqlserver 2008 reporting services in a new server. do i need to install the full version of sqlserver 2008, or just reporting...
In a new server , we installed windows 2008 (X64 bit) and sqlserver 2008 (64 bit) enterprise edition. after that do we need to install any service...
Separate names with a comma.
