When you create a temporary table it is in scope for either the duration of the batch (Local Temporary Table) or for the duration of the connection (Global Temporary Table.)

A...

SQL Server has a database it uses as a scratch pad.  That database is called tempdb.  Anytime a table is created with a Pound Sign (#) as the first, or...

What you are using is called and Associative table.  Others call it a Cross Reference table while still others call it an Intersect table.

Creating two tables where...

Lookup CREATE DEFAULT

and sp_bindefault

Are you BCPing data into the table?

Do you manually insert data into the identity column with the IDENTITY_INSERT option set ON?

Are you resetting the Seed value of the Identity Column?

SELECT CAST(FLOOR(CAST(GETDATE() as float)) AS smalldatetime)

Simple.

select CAST(FLOOR(CAST(GETDATE() as float)) as datetime)

This:

1: Converts a datetime to a floating point number

2: Truncates the decimal postion (time) of the floating point number without changing the value of the...

To shrink a database use

DBCC ShrinkDatabase or DBCC ShrinkFile.  They are both in help.

Remember, anything can be done via code.  The Enterprise Manager's GUI just generated the proper SQL and executes...

Use what you need.  I use these for moving and rearranging data. 

--Backup is run on the Server where the database is

USE MASTER

GO

DECLARE  @Description varchar(255)

        ,@Name        varchar(255)

        ,@Location    varchar(255)

SET @Description...

Use what you need.

DECLARE @Date  Datetime

DECLARE @Days  int

SET @Date = '01/01/2004'

SET @Days = 0

WHILE @Date <= GetDATE()

    BEGIN

    IF DatePart(weekday, @Date) BETWEEN 2 AND 6

        SET @Days = @Days +...

You've got me stumped... but that doesn't take much.  Hopefully someone with more knowledge that I will help you.

Good luck and sorry I couldn't help.

Do you have sysadmin priviliges?  If not, as someone with sysadmin to try.

Also, try this... although I don't think it will work.

Use Master

EXEC sp_Helptext 'Information_Schema.Tables'

Can you view the INFORMATION_SCHEMA views

There is a way but it's not pretty.  Create, or have your c++ programers create a program that uses as an input a file location and as an returns the...