Help with SQL Statement.

I'm sorry to bother but I can not find a solution for this problem: I have 2 tables as follows: Tab…

corrupt date column

SQL Server 2000 Ent I am seeing random pieces of code appended to some of the dates in the 'Create …

IIS Support for SQL 2000 on Windows 2003

I am trying to configure an IIS virtual directory on Windows 2003 server SQL Server 2000 for access…

Get list of columns associated with an Index

Other than Enterprise Mgr, is there a stored procedure on sql server or some SQL code which will re…

fetch - Table1 ''Belongs to object error'' Table2 Error ... Help!

Hi:  We're running a DTS that simply pulls data from one TABLE into non-db file.   A…

Transfering SQL instances from one cluster to another

  Hello, has anuone done this and has a suggestion to do it in a particular way? Situation: Ru…

varibles

Platform

What platforms do both ORACLE and SQL Server Support and how ? if anyone know where can i get more …

Custom Auditing with Triggers and User Tables

I have a small dilemma and hopefully someone can give me some insight. I have to create auditing tr…

RS Books Online

Where do I get a download for RS books online? The only download I can find at Microsoft is an upda…

DB Recovery!!

Goodafternoon everybody Can anybody pls inform is there any way to recover a database which is acci…

WHERE IN help needed

I have a list of employeeids in a comma seperated string (688,708,87,88). I'd like to be able to pa…

Search Stored Procedure Code

I need to be able to find/search for all instances of a string in all stored procedure code for a p…

Does VS.NET 2003 take advantage of SQL 2005 CTP ?

Sorry for the newbie questions, I am completely new to Yukon.   I connected to remote SQL Serv…

Replication Program Problem

Hiii, I have set a transactional replication. For some reasons Distribution agent fails . Hen…