Dear All, For last few days on my server, sql server is using more than 80% CPU almost all the time, i find out all the thread id, KPID which is using more...
Hi All, I am facing the problem in DTS Packages, When I restered the server or SQL Services then the problem didn't come for some time but later on again it's...
Hi,In SSIS, I would like to pass the file path name as a variable from data reader source to Flat File Source dynamically ? Any suggestions ?Thanks,Ravi ...
Hi There is an issue currently in my project. We want the data in the report to be toggling and at every instant the total should come up dynamically. Please...
Hi All While Execution of SQL Statement..Getting following Error... What may be solution for this.... [Microsoft][ODBC SQL Server Driver]Protocol error in TDS...
Hi Team. Anyone has recently completed the MCDBA Certification and/or having Dumps for the same for the papers such as 1. SQL Server Administration 2. SQL...
Hi Team. Anyone has recently completed the MCDBA Certification and/or having Dumps for the same for the papers such as 1. SQL Server Administration 2. SQL...
Enter your vote today! A new poll has been created for the sqlcon group: Are you ready to upgrade to SQL Server 2005 when SQL Server 2000 version mainstream...
sqlcon@yahoogroups.com
Sep 4, 2007 8:03 pm
5652
The following sqlcon poll is now closed. Here are the final results: POLL QUESTION: Do you think Microsoft should speed-up 'Katmai'- next release of SQL...
sqlcon@yahoogroups.com
Sep 4, 2007 8:04 pm
5653
Dear santosh, below link may help u.. http://support.microsoft.com/kb/140536/zh-cn http://support.microsoft.com/default.aspx/kb/176256 ...
Hi Friends, In my SQL Server error log, I am getting this error 2-3 times. 2007-09-03 10:30:04.52 Logon Error: 17836, Severity: 20, State: 1. 2007-09-03...
Hi, I need to change Datatype in replication. Can anyone tell me how can i do without drop publisher.. Thanks Manish ... Need a vacation? Get great deals to...
I hope you need to disable the Replication first,then change the datatype in both the Publisher and Subscriber and set up the Replication again Regards, Shaik....
Hi, First we need to remove the article from the publication, make respective changes and then add back to the publication. Thanks, Kishore. ... From: Manish...
Hi, Go to distributor server (Enterprise Manager) Open Replication monitor Right click on the Publication which contains the article Select properties and go...
What is the exact problem you are facing because of this error message? Shade some more light on this. At first glance, looks like a network protocol issue to...
Can anyone tell me to configure the database mail. it seems to be simple and i have made all the entries but unable to connect. i cheked the log i am getting ...
Hi Kishore, Thanks for ur help, but i am not able to unselect, as sql server wont allow me to do so. manish kishore <kvkishore79@...> wrote: Hi, Go to...
Disk drive information in vb.net System.IO.DriveInfo <http://dotnetolympians.wordpress.com/2007/09/06/disk-drive-information-\ in-vbnet-systemiodriveinfo/> ...
Hi All, I've written the below query to find out default or named instance. When I execute the query in default instance(SQL 2005) , I'm getting output as ...
Try this one... if (serverproperty( 'instancename' )) IS NULL begin Print 'Default Instance' end else begin Print 'Named Instance' end RK. Vidhya Sagar...
Hi Ramesh, Thanks its working.. I forget to use IS command.. Cheers.....Vidhya Sagar.....+91 98843 97975 From: Ramesh Karnati [mailto:karnati_in@...] ...
Hi Group - I have the following 2 issues and looking for solution or pointers: 1)---------------------------------------------- Issue: Inserting data from SQL...
Hi All, While using select statement im getting output along with column names and with "-------------------------" strings. Is it possible to remove column...
Hi, You must have selected the execute mode as Results as Text, select Results as Grid or (Ctrl + D) for a solution. hope this is what you have asked. gud luck...
In the if condition replace NULL with your system name ,as when you select @@ servername if its default instance you can see your box name Thanks Vijayasekar ...
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.
