We have developed a complete system in VB.net & SQL Server 2005. That take care about Inventory Management, asset management, HR, Accounts, Order...
Please tell me how to debug a Stored Procedure in SQL Server 2005.
I have Trend Micro -Client Server Security for SMB on my Server
It is a dedicated SQLServer.
There is no Network Issue as hardly 10 users r connected...
Windows 2003 R2 Service Pack 1
SQL Server 2005 Service Pack 1
Server is responding slow against Queries....even in loading Management Studio.
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.
Could you please tell me how to use Performance Monitor & Trace to monitor performance problem issue of a production server.
I was restoring database from backup. After restoring the complete backup, I was restoring Transaction Log Backup. in last Trn Backup file I forgot...
SELECT CONVERT(char(50), SERVERPROPERTY('collation'))
Returned the same (Old one) collation.
Even in properties of Master it is showing old...
I followed the same steps after stoping all SQL Services and In Single User Mode:
To rebuild system databases and specify a new system collation...
I want to change the collation from SQL_Latin1_General_CP1_CI_AS to SQL_Latin1_General_CP1256_CI_AS
I follow following steps:
I am using full recovery model.
Thanks for update.
Means u must go for third party tool.
One of our client using sql server.
They had some corruption at some point on 20th March, 2007 in their SQL Server Database.
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...
U got my point.Let me try to find out....
This UDF is working allright in my Production Server...there is no error.Then why it is giving error in replication...? Or I m missing...
I m using SQL Server 2005 Standard Edition SP1.
I am doing Transaction Replication between my production Server & standby server....
thanks a lot Mr.Mahi & everybody participated.
Separate names with a comma.