Dear guys, please help me. i am facing a problem. in one pc there is a database with named business.mdf and business.ldf files. I have copied those files and...
HI All I have got a big performance issue in one of the application . There are two many udf used , of these many are returing table . Can this be a bottleneck...
Hi Ram, Thanks for your great help. It is working fine for only master database, for other databases it is not working; the database size is not refreshing(it...
you can find out the execution time using the execution plan of that query. But its not good or advisable to set the command time out based upon its execution...
Hi , I am stucked up in taking few decisions and need your help. I am deleting some 3 million records from two table's, and then doing BCP out using format...
#Bug 1 Junk Record is in the Yukon (SQL 2005) Note: If you transfer the data from sql2000 to Sql2005 then please be careful about some point When the Bug...
Hi Vasa, Run the below script also in Master after creating the SP, and then try. EXEC sp_MS_marksystemobject SP_GetDbSize It's interesting to know that,...
Hi Can any one tell me how to create a group and user in sql server 2000 programmatically in C#? Is there any system stored procedure to do this one? I want to...
THAT WAS A NICE DOCUMENTATION Biswajit Das <radhye@...> wrote: #Bug 1 Junk Record is in the Yukon (SQL 2005) Note: If you transfer the data from sql2000...
Hussaini, How are you copying those files after detaching them? Are both the SQL Servers running on same code page? Try the following: Try to attach only the...
I recolmmend checking the file paths of the Files...as headers often cause problems because of File location Issues... Just synchronise the file paths of...
Hi,. Transact-SQL statements for Granting, Revoking and denying Windows Logins. Stored procedure sp_grantlogin 'DOMAIN\User or Group name' Grants an existing...
920
community@...
May 2, 2005 4:15 pm
If you are unable to read HTML emails, please visit: http://www.infragistics.com/scripts/redirects.aspx?ID=NWSLTR-0505-UG Last year InfragisticsĀ® officially...
I am answering your points one by one..However it is beautiful example to demonstration..:):):) I would like to know how 1) this will impact query execution,...
There are few ways I can suggest at a fly Monitor the System performance and check the Queries that are bottlenecks for their IO Stats Dont jump Straight to...
Dear Murtaza, Please follow these steps to attach a copied database. 1. copy .mdf(.ndf if any with .mdf) and .ldf files 2. put these files in another system's...
Dear Murtaza, Please follow these steps to attach a copied database. 1. copy .mdf(.ndf if any with .mdf) and .ldf files 2. put these files in another system's...
Excellent. Hope you would keep on helping us with new things. Thanks Satendra ... === message truncated === __________________________________________________...
Hi, Have a customer who uses our application software with a export feature for GL info. They claim that when they run the export, their SQL server CPU spikes...
Hi Sanjay Biswajit here from this side. Let disscuss the practical senario how to optimization the Bcp query .i am giving all the case when you face problem...
dear friends i need a vb code for importing mysql database to access database and vice versa itz very urgent and i am stuck up at this point in a project...
Hi All, The sp4 is released & uploaded test it out on your test boxes http://www.microsoft.com/sql/downloads/2000/sp4.asp ... Moved to MDAC 2.8 SP1, the latest...
hi, My transcation Replication is not funcitoning consistenly over a period of time. Every time it is having a new problem. We have two sql 2000 servers ,...
Hi, Well looking into the issue with the information given by you is not quite enough. Would it be possible to send following details across to the group. 1....
Hi techies, Go through this site. Recently we implemented transactional rep using this article , initially we had faced lot of issue to suite our requirement...
In order to secure an Access database I have secured the MDB using the Wizard. Next I'm making a copy of it. The copy will be the back end. (I'm not using the...
Hi I am having a opening in Dubai/Hyderabad ASP SQL with 1.5+ exp. Please in your resume to lathainfotech@..., lathainfotech @gmail.com<http://gmail.com>...
Hi Friends, Since every RDBMS is based on the great CODD's Rule can anyone tell how many rules SQL server 2000 is following ? Any idea about SQL server 2005 ? ...
