I have SQL 2000 Enterprise running with replication, i wanted to downgrade it to SQL 2000 Standard, is there any way we can download / install SQL 2000 standard without losing any configuratio...
I need to build a recursive CTE to return a tree from a database table
I am working in Reporting Services SSRS 2005. I have six parameters which is being parsed to generate a report. Now i want to show and hide columns passing the parameter; Here's what i did;
...
Environment:
Windows 2003 domain controller (dc)
Windows NT4 server contains SQL7 database (myDB).
myDB is configured to use Windows authentication.
Q#1. How to specify which network use...
Here is my problem :
Two tables called Certifications & Employees
e.g.
Select * from Certifications C, Employees E
where C. Employee_I...
I have a table with a fullname field that is somewhat complex with middle initials, middle names, and even some 'Jr.' stuff at the end. I need a good name parsing function.
So I can do som...
I've created a insert and update trigger on a table. The update trigger runs fine, but the insert trigger runs sometimes.
We just added another drive partition (D:\) to an MS SQL 2005 installation. As far as creating new DBs on that drive space, do we need to do anything to get SQL to create them there?
If I ...
The following query returns a set of results starting with the below. Once the items start changing, the results are as expected - one row per item and everything is as expected. I checked t...
I have SQL Server 2000 and I want to upgrade to 2005. How do I find out if I am using
Enterprise, standard or developer.
Usually under help, there is an "About" option which gives this ...
I am using coldfusion and SQl to make a time Sheet system that people clock in and out.
I need the following.
A sql statement that when someone clocks out will get the date difference i...
Which of the three clauses are equivalent please:
(1) FROM a LEFT JOIN b ON x=y LEFT JOIN c ON xx = yy
(2) FROM (a LEFT JOIN b ON x=y) LEFT JOIN c ON xx = yy
(3) FROM a LEFT JOIN (b LEFT JO...
Trying to increase the RAM for 4GB in Sql 2005 ENT server 32 bit
Below Steps done:
1. Enabled AWE
2. Append /3GB /PAE in Boot.ini file
3.Assigned service Account with NT login ID and ...
hi all i have the following ms sql server stored procedure but its throwing errors can any one tell me where im going wrong
PROCEDURE [dbo].[addNewSubjectategory]
(
@subjectId int,
@t...
I have a table garages that I need to update the longitude and latitude fields from another table called longlat
The tables are as follows:
garages longlat
id ...
In SQL Server 2005, what can cause a primary key violation on insertion of records into a table, BESIDES inserting records with duplicate data on that primary key?
I have a SQL table with ...
I am trying to capture all operations by a specific SQL Server UserId and the hostname from which the statements were issued. It seems a SS trace will provide the file I need to chew on to ge...
How can I search and replace a word in all records in a table?
Example:
In tblTable I have a column called "BodyText" that stores alot of text. Inside this text I need to replace the word ...
So, I am curious if anyone has be involved in an ISV project that reads the SQL Server transaction logs? There are programs such as Lumigent and Apex that are able to read the logs....apparen...
Currently working on a Stored Procedure and I'm having a bit of problems with the parameters within it and hopefully someone can point me in the right direction.
My current code is attached...
Hello,
I have a MS SQL Server 2005 DB. I would like to have a table with 2 columns. 1) is a name and 2) is a random generated alpha numerical code of 10 digits long. I would like to generat...
How do I convert or move an SQL2000 database to SQL2005?
Background: In Sql Server, I have a table of documents tDocs, and have queried a subset. tDocs may have 500,000 records, my subset may have 100,000. I want to loop through the subset and as...
I have a table (Rules) with a RuleID and RuleSQL, and this rule is used to assign tasks to a particular role. So for example role ABC can view all items of type A. So I have a table that hol...
I am trying to relocate the SQL 2000 System databases to a different drive, I have done master and relocated tempdb but I can't find how to move model and msdb, tried doing it via a backup and...
