Viewing 15 topics - 270,901 through 270,915 (of 274,583 total)
Replicating between two SQL 2000 SP 1 machines. (One with a binary sort order, one as default.)
18 years, 12 months ago
By: Andy Warren
Will the result from queries having the following two formats be different,
I am attempting to translate the following access code into T-SQL as part of a large sele…
1. What is the minimum role or permissions a sql user needs to execute DBCC FREEPROCCACHE?
2. How a…
I am trying to write a stored procedure where i select a bacodeNo field from a table then convert t…
There are 2 "tables" in the unidata db. Contractor_master(CM) and Contractor_Driver_Profile(CDP.
I’m in the process of creating some general error checking before running a DTS package. Here are…
18 years, 11 months ago
In: Data Transformation Services (DTS)
[SQL Server 2000 Enterprise]
I just restored a user database to another server. I am trying to give…
By: David Benoit
how does one change the object owner of a user defined data type?
14 years, 8 months ago
By: Leonard Mwangi
How do you change the Lock TimeOut in SQLServer6.5?
By: Willem Langendries
I HAVE A TABLE EMP WITH COLUMNS EMPNO,ENAME,SALARY and also a column MOD_DATE
WHEN EVER I UPDATE SA…
I am new on sqlserver ( better said very new ) .
I have problems running jobs , i am lookin…
SQL Server 2000
The database files are distributed in 2 physical disks (which are assigned to 2 use…
I am trying to drill into the specific tables causing page splits to occur, we are taking a …
In: Performance Tuning
1)i want to know if i did some structure changes in source table of a publishing database.