FOREIGN KEY on Temporary Table?

Question: Is is not possible to add a FOREIGN KEY constraint on a local or global Temporary table? …

Help on web multiple web forms.

CREATE TABLE Lookup_User_Title ( [TitleID] varchar(10) primary key, [TitleText] varchar (10) not nu…

what is clustring

Question About DEFAULT

If I have the need to create a new field for a table where records already exist, and that new fiel…

Review Lookup Tables...

Can someone check my logic here my main table I creared is at the buttom. How can I implement this …

Help on T-SQL

I am building a six page survey and I was wondering if u could give me a few tips or if u know of s…

Database connection loss

I have a four page registration page. I would like to be able to keep storing user data in db after…

Version Control

Does Microsoft make any version control software that integrates into Enterprise Manager?

SQL Design Patterns and Refactoring?

I like the Design Patters and Refactoring books, but they are pretty much OOP. Does anyone kno…

Trying to Debug a Bug in the Debugger

In Query Analyzer, I right-click on a stored proc to bring up a menu, and select Debug... at the bo…

Phantom system stored procedures

I have a bunch of dt_%  system stored procedures in my database but can't delete them.&nb…

How to Browse for SQLServer instances

How do you find out what SQLServer instances there are on a network?   Thanks in advance.

Service Packs

Wondering if anyone knows when the next service pack will be released? We're using SP2 with HF679, …

xp_sendmail problem

I have a stored procedure runs twice a day to send alerts email to people. portion of sp : EXEC @s…

if -- else with ALTER PROC and CREATE PROC

What can be done to create/alter a stored procedure.   if exists (select * from dbo.sysobject…