Friends, Adobe Systems, Noida - Requires MSSQL DBA with around 5 years of experience. Profile: Infrastructure DBA (experience in Database infrastructure...
6600
radhye
Jun 9, 2010 12:12 am
Biswajit Das USA Stamford Connecticut 908 494 8632  Hi  I have more then 11 year’s experience as a SQL SERVER DBA also good experiences in BizTalk and MQ...
6601
sunil john
suniljk7
Jun 18, 2010 9:53 am
Hi all, I am facing an issue on sql server 2000 with sql agent job history. below are the details Box- Windows 200 server Sql server 2000 with sql4 Only one...
6602
SARADADEVI
sv_39
Jun 18, 2010 12:38 pm
  Is these jobs created on cetralised server or remoted machine.if yes then you won't able to see in local machine.  ... From: sunil john...
6603
sunil john
suniljk7
Jun 19, 2010 4:05 am
Thanks for the reply, the jobs is created for local machine and i am looking at same instance msdb sysjobhistory table, but no entry in the table. please help...
6604
Rakesh Kumar
hisinha_rakesh
Jun 20, 2010 4:57 am
Hi Sqlcon, I set up a Facebook profile where I can post my pictures, videos and events and I want to add you as a friend so you can see it. First, you need to...
6605
jacob.sebastian
Jun 21, 2010 7:59 am
Very interesting article by ASP.NET MVP Hima on Connection Pooling. Connection Pooling is the ability to reuse the database connection for more than one user....
6606
jacob.sebastian
Jun 22, 2010 11:36 am
This post intends to help you get started with OPENXML() function. OPENXML() lets you shred an XML document or fragment into a result set. ...
6607
Santhosh
san_spy
Jul 15, 2010 8:16 am
Hi All, We have some 3 openings for SQL Server DBA in our company. Our Company name is Tesco, if any one is interested please sent me your resumes. You should...
6608
bugzzbunny@...
abhishekgohil
Jul 15, 2010 10:45 am
Hello , When Google, Facebook and Twitter was launched, no one thought that it will become our necessity, I come to know a very interesting and innovative...
6609
bugzzbunny@...
abhishekgohil
Jul 17, 2010 11:37 pm
Hello , When Google, Facebook and Twitter was launched, no one thought that it will become our necessity, I come to know a very interesting and innovative...
6610
rakesh dhar
rd_rakesh
Jul 20, 2010 8:28 am
Hi Friends, Please help me for this Question . How may Tables can we use in a Join (any Join Inner,Outer,Left.....) in SQL 2005. 10,20,50.......300 Tables ...?...
6611
Nithin Mohan T K
nithinmohantk
Jul 21, 2010 12:10 am
There is no limitation as far as I know. Any number you prefer you can use, the more the join, the slower the fetching of data. From: sqlcon@yahoogroups.com...
6612
Shyam Sunder
shyam_k25
Jul 22, 2010 9:13 am
Hi All, Here a i have a problem with in Database mirroring environment. I have a huge unsent log in Asynchronous (high Performance mode) Its current...
6613
Santhosh
san_spy
Jul 22, 2010 9:59 am
Hi Shyam, Basically the sending rate depends upon your network speed. 452 kbps looks like bit slow. Why is it low is your network over loaded or are you doing...
6614
SARADADEVI
sv_39
Jul 22, 2010 1:22 pm
How to take tail log backup in SQLServer. [Non-text portions of this message have been removed]...
6615
Santhosh
san_spy
Jul 22, 2010 2:01 pm
Tail log backup is nothing but transaction log backup. Basically in case of database failure the last transaction log backup taken before recovering the ...
6616
Manish Sharma
connect_manish
Jul 27, 2010 7:51 pm
Hi, I need to set Password to expire in 80 days in SQL 2005. Can anyone help to tell me how should i do it. I think i also need to change the windows...
6617
SARADADEVI
sv_39
Jul 28, 2010 12:45 pm
In my environment Login Auditing is currently set to "Failed Logins Only" This is probably a carry over from the old servers were it caused excessive log...
6618
Santhosh
san_spy
Jul 28, 2010 4:05 pm
Hi, The solution for this would be as we cannot reset the error log based upon the size. 1. Configure the number of error logs to say 99. 2. Create a job to...
6619
bugzzbunny@...
abhishekgohil
Jul 29, 2010 11:23 pm
Hello , When Google, Facebook and Twitter was launched, no one thought that it will become our necessity, I come to know a very interesting and innovative...
6620
SARADADEVI
sv_39
Aug 3, 2010 4:29 am
Hi,   I changed the “page_verify_option” set to CHECKSUM in production server.  My DR database “SAP” is in "Restoring" does this stop the setting...
6621
bugzzbunny@...
abhishekgohil
Aug 13, 2010 9:56 pm
Hello , The Concept is great, We Learn, Earn and have Fun same time & Its FREE. No buying/selling, the website earns from advertisers and sharing profit with...
6622
Ramesh
ramesh.golla...
Aug 24, 2010 7:20 am
I have a database with different schemas, and I was asked to restore only DBO schema from the lightspeed backup file. Is there any way to restore a single...
6623
mohd rizwan
mo2riz
Aug 24, 2010 9:06 am
IÂ never did it but I think you can do it.....I copied Litespeed help content below. Â Restore Schemas in the LiteSpeed Console Before you can recover...
6624
Shashi Kumar Singh
shashi_120
Sep 1, 2010 10:12 am
Hi, To take log backup you need to give this command: BACKUP DATABASE DB_NAME TO DISK='PATH\BACKUP_NAME' WITH NOTRUNCATE_ONLY ... -- Thanks & Regards Shashi...
6625
bugzzbunny@...
abhishekgohil
Sep 5, 2010 1:30 am
Hello , The Concept is great, We Learn, Earn and have Fun same time & Its FREE. No buying/selling, the website earns from advertisers and sharing profit with...
6626
SARADADEVI
sv_39
Sep 9, 2010 2:14 pm
Hi We requires that unsuccessful and successful login attempts be logged With the excessive log files now being created is it recommended/approved to only...
6627
Santhosh
san_spy
Sep 9, 2010 2:44 pm
It all depends upon your requirement. If your audit requirement requires for both successful & unsuccessful logins, you have to record it. Put a script to ...
6628
Santhosh
san_spy
Sep 9, 2010 2:45 pm
Also increase the error log count to 100 or 200 as per ur audit requirements. With :))s Santhosh Kumar S.J - MCTS ReadMe @ sqlspy.blogspot.com ReadMe @...
