We have developed a complete system in VB.net & SQL Server 2005. That take care about Inventory Management, asset management, HR, Accounts, Order...
Hello Frinds, Please tell me how to debug a Stored Procedure in SQL Server 2005. Thanks, Regards, Tfakih
Hello Friends, I am using Sql Server 2005 with Windows 2003 Memory of Server is 4GB. This is a new server & database size is hardly 500MB now. I...
I was restoring database from backup. After restoring the complete backup, I was restoring Transaction Log Backup. in last Trn Backup file I forgot...
Hello Friends I want to change the collation from SQL_Latin1_General_CP1_CI_AS to SQL_Latin1_General_CP1256_CI_AS I follow following steps: To...
Hello Frinds, One of our client using sql server. They had some corruption at some point on 20th March, 2007 in their SQL Server Database. They...
Dear Friends, I have installed SQL Server 2005 in my Stand by Server. Standby Server is on same domain.Now when I am regestering My Stand by Server...
Dear Friend, I m using SQL Server 2005 Standard Edition SP1. I am doing Transaction Replication between my production Server & standby server....
Dear Friends, I am using SQL Server 2000. I changed the password of Windows 2000. My SQL Server was running on Windows Authentication mode. SA...
Dear Friends, I am using SQL Server 2005 standard edition. My database size is 500MB but the Transaction Log file size is incresing day by day now...
Dear Friends, I am using sql Server 2005 standard edition...Due to some maintenance work I changed the IP Address range of DHCP.The DHCP server &...
Dear Friends. Can u please tell me how to create DTS package in SQL Server 2005. There is no option for DTS in 2005. I m new to 2005. Please guide...
Dear friends, We have a system developed in .net using SQL 2000 as backend. Now we have Installed SQL 2005 Standard Edition on new server. We are...
Hello Friends, I am working on a new project in which my database is online on web. I want to know how to secure my database on web? What are the...
I did publication process of replication successfully but when I run subcription to my standby server it is giving following error : Line 20 :...
Can u tell me how can I stop System Administrator to enter in SQL Server 2000. He can enter in SQL Server using Windows Mode. Thanks, Regards, Tfakih
Sman_IDOrderDateOrderQty 57/4/199632.38 67/5/199611.61 47/8/199665.83 37/8/199641.34 47/9/199651.3 37/10/199658.17 57/11/199622.98 97/12/1996148.33...
Can u please tell me how to store date in DD-MM-YYYY in SQL Table. i.e "Apr-01-2006" to 01-04-2006 ? I have a source that need to be upload to SQL...
I want to create a SQL DTS package to perform the following: - Users upload excel files periodically to server with the same column - Once an excel...
I require a SQL DTS package to perform the following: - many users create excel files periodically to server - Once an excel file has been...
Separate names with a comma.
