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. ...
6365
koushik roy
koushikroy_2001
Mar 9, 2009 12:46 pm
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...
6366
Manish Sharma
connect_manish
Mar 12, 2009 7:06 am
Hi, Last week we have migrate our Db from SQl 2000(32x) to SQl 2005(64x). After that our delete query is taking longer time(around 30 Mins) whereas...
6367
koushik roy
koushikroy_2001
Mar 12, 2009 12:30 pm
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...
6368
Hemantgiri S. Goswami
hemant_goswami
Mar 13, 2009 2:00 am
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...
6369
Gigme Chittayath
gigmepc
Mar 13, 2009 2:59 pm
Manish, Take a look at whats going on while the delete operation is running. Most likely something is blocking the delete operation.Make sure no...
6370
sunil john
suniljk7
Mar 15, 2009 6:13 am
Dear Koushik, I think we can't hide these from a user. experts please correct me if am wrong. Best Regards Sunil John ________________________________ From:...
6371
Sandeep Chanda
sandeep_chanda
Mar 16, 2009 10:51 am
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)...
6372
Vijay Mishra
mishravijay
Mar 16, 2009 1:32 pm
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 ...
6373
Santhosh
san_spy
Mar 17, 2009 4:22 pm
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...
6374
Santhosh
san_spy
Mar 19, 2009 12:30 pm
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...
6375
Anand Kumar Reddy
anandkreddy
Mar 19, 2009 1:39 pm
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..... ...
6376
chaitanya reddy
schaitanya_r...
Mar 20, 2009 7:25 pm
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...
6377
Santhosh
san_spy
Mar 21, 2009 6:12 am
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...
6378
muthu narayanan
avm_narayanan
Mar 21, 2009 10:25 am
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...
6379
chaitanya reddy
schaitanya_r...
Mar 23, 2009 3:33 pm
Hi Santhosh, Thanqu for Replay.It possible to restore master database to restore in another server, But logingns,database entries,backup device informations...
6380
vijayasekar shanmugha...
vjsekars
Mar 23, 2009 4:41 pm
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 ...
6381
Anand Kumar Reddy
anandkreddy
Mar 24, 2009 11:58 am
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...
6382
Veer Ji Wangoo
vwangoo
Mar 24, 2009 6:03 pm
FYI From: PASS Headquarters [mailto:sandy@...] On Behalf Of PASS Headquarters Sent: Tuesday, March 24, 2009 10:45 PM To: Veer Ji Wangoo Subject:...
6383
Saiganesha SAI via Ya...
sv_39
Mar 25, 2009 1:29 am
Join sai sarada on Yahoo! Messenger. Stay in the loop with all your friends. Get started :...
6384
Santhosh
san_spy
Mar 25, 2009 8:09 am
Hi Chaitanya, This kind of scenarios will be helpful in the cases like physical server to virtual server migrations. Migrations where the server properties...
6385
SARADA DEVI
sv_39
Mar 25, 2009 4:13 pm
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...
6386
SARADA DEVI
sv_39
Mar 25, 2009 5:13 pm
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...
6387
virender mann
virenmann
Mar 25, 2009 5:20 pm
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...
6388
SARADA DEVI
sv_39
Mar 26, 2009 1:30 am
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...
6389
virender mann
virenmann
Mar 26, 2009 7:19 pm
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...
6390
Veer Ji Wangoo
vwangoo
Mar 30, 2009 11:54 am
... 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...
6391
Santhosh
san_spy
Mar 30, 2009 1:37 pm
Veer, Can you resend the numbers? We are unable to open the attachment. With :))s Santhosh Kumar S.J - MCITP ReadMe @ sqlspy.blogspot.com ReadMe @...
6392
Veer Ji Wangoo
vwangoo
Apr 2, 2009 7:51 pm
... 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...
6393
vijaya_krishna_birju
vijaya_krish...
Apr 12, 2009 11:00 pm
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...
