Differences between SQL Server Profiler in Standard and Enterprise Edition

Hi Friends, Is there any differences between SQL Server Profiler in Standard and Enterprise Edition…

setting the query time out user specific

i am using sqlserver 2000, and i was wondering how do i go about setting the query time out. is the…

An OLE DB error 0x80004005

is there another way to deploy a report??

when ever i deploy a report i have to do the following: update Visual Source Safe (Get latest versi…

SQL 2000 & 2005 co-exist in same cluster?

Hi, Does anyone know whether SQL 2000 & 2005 can both installed on same cluster enviroment? an…

Uninstall

I have been trying to install sqlserver 2005 on a cluster node(2).  I am receiving errors and …

Week() Formula in VB/Reporting Services

Is there a function in VB/Reporting Services to calculate the week of year of a given date, similar…

Replication v Log Shipping v Mirroring

Hi All, Can someone please help me distinguish between the various types of availability modes as a…

Get  all user tables with size

Comments posted to this topic are about the item Get  all user tables with size

A Simply way to implement Audit Trail in SQL 2005

Comments posted to this topic are about the item A Simply way to implement Audit Trail in SQL 2005

Find Trigger Status

Comments posted to this topic are about the item Find Trigger Status

ESRI SDE SQL SERVER 2005

We moved our DB from 2000 to 2005, no problems. We run a script that loads polygons (GIS) from a di…

Alternatives to cursors in T-SQL

I have read "Down with cursors"  Fine, but these individuals that have supported this are…

How to change the server name dynamically in the BCP

DW.dbo.orders out \\SQLD003\Mart\Backup\NewChanges\orders.bcp -c -m1 -S SQLD003 -T here the table o…

processor speed recommendations for SQL Server 2005

Does anyone have any recommendations for processor speed for SQL Server 2005? We are a medium sized…