Viewing 15 topics - 266,266 through 266,280 (of 268,818 total)
My company is running a CRM application with a SQL backend. At times I run into deadlocks caused b…
17 years, 7 months ago
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
When should this be used ?
CREATE TABLE [Products] (
[productid] [int] NOT NULL ,
[sku] [varchar] (50) AS NULL ,
I am having major problems trying to use Transact-SQL cursors. Things that I can easily code using …
Im trying to get transactional replication to work between two different domains across a private T…
I have a database consisting of around 60 tables that are all based on eachother. The whole…
In: Data Transformation Services (DTS)
By: Andy Warren
I would like to create a scheduled stored procedure that queries the data base, produces an XML doc…
By: Leon Platt
I currently have a small demo program.
It is a VB.NET project.
In this Program I hardcoded a string…
We have a DTS job which uses a linked server to an Oracle server and inserts data into an SQL Se…
How do I actually make use fo the bulk copy program(bcp) to take in my query and export the data in…
How to i validate the syntax of all views & stored procs in my DB?
Ive had numerous sen…
I have a database which was created with unrestricted growth. The log file space is 209 mb. I wou…
In the profiler I have observed
SET NO_BROWSETABLE ON and OFF statements, what is the significan…
For some very strange reason, my once working linked server via ole-db sqlserver provider do…
I have a big backup file which contains multiple backup version. And I got the following instructio…