Hi Team, have you ever send a file as a attachment by running it from cmd prompt. how to do the same? If do you know how to do the same?Please let me know. ...
Hi Team, We have a request from client to hide all system views/tables from users in SQL server 2005. As user assigned to a specific database role, client do...
Hi Manish, I think you need to verify your existing indexes for tables in sql server 2005. re-build the indexes if possible. Also, you need to run below on...
Hi Manish, You will require to update the statistics so It is always advisable to run index rebuild / update statistics on the the databases when you move to a...
Dear Koushik, I think we can't hide these from a user. experts please correct me if am wrong. Best Regards Sunil John ________________________________ From:...
Hi All, We have an urgent requirement for MOSS (Microsoft Office SharePoint Server). Please little 'r' to me if you are interested in the following profile: 1)...
Hi Guys, I am looking for a SQL Server developer in my team with an experience of atleast 3 years. The opening is based in Hyderabad and this team serves the ...
Hi Guys, I need to restore the master database of a clustered server in a non clustered server. Does any one have any recommendations or Do's Don't regarding...
Hi Guys, In our company we have an opening for SQL Server DBA with 6+ yrs of relevant exp. It will be more like a architect kind of position. Apart from...
Hi, There will be no difference whether of a cluster or non cluster server for the master database restore. Let me know if u require any further details..... ...
Hi, your question is not clear how can you restore master database of one server to another server its not posiable.if you have any answer please explain with...
Chaitanya, My Question is Can we restore the master database of a clustered server to a non clustered server if yes what is the Do's and Dont's //how can you...
Hi Santhosh, you can restore the master database if you have master databse backup file. It doesn't have any relation with cluster ,it purely with sql...
Hi Santhosh, Thanqu for Replay.It possible to restore master database to restore in another server, But logingns,database entries,backup device informations...
Try increasing to "Minimum memory for query" 10 mb (10240 KB) from 1 mb On Fri, Mar 13, 2009 at 7:29 AM, Hemantgiri S. Goswami < ... -- Thanks Vijayasekar ...
Hi Chaitanya, Its up to you when to use this option, but we can restore the master db back in other server. Ex. If you want to create a replica like...
Hi Chaitanya, This kind of scenarios will be helpful in the cases like physical server to virtual server migrations. Migrations where the server properties...
Hi , If we want add extra GB in database mirroring first where we have to add like principal server or mirroring server then 1) If we add extra GB in principal...
I am trying to monitor following items: 1. Logins 2. Logouts 3. Loginfailed 4. Exixtence of users or ID in the server 5. Also, For example, we have two groups...
Hi Sarada, You don't need to worry about anything just take follow the steps: 1. Take Complete Backup (Just as a Precautionary Measure) 2. Increase the file...
Hi, Suppose, user complains that it is timed out each time he/she tries to access the database from application. How can we find out what is the problem in...
Sarada, You can set it up using sp_configure or SQL Server properties. And you can capture the login failed, login success or both. =>In SQL Server Management...
... The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the...
... The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the...
Today I will explain about the different ways to add a NOT NULL constraint on a column. Advantages of NOT NULL constraint: 1) You can prevent users to enter...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
