it sounds to me that the file is just a SQL Server backup; at our shop we see backup files with no file extension, some end in .BAK, others with...

As you'll see in david's example above , a calculated field must explicitly name the columns to be calculated; you cannot reference fields by column order, because the column order...

When i first read this i was confused as to whether you were asking for the table design/schema, or the sql to get the data;

Assuming you already have the 3...

if VarCarCol is null, you wouldnt't  get an error when comparing null > 1 in SQL server; but in another application or programming language you would:

in my sample table REFERENCENBR...

probably obvious to everyone that you can avoid the variable and just us an if exists:

IF exists(select * from test_tbl)

    raiserror('Your Error Message Here',16,1) with log

else

    print 'Good to...

you want to use a sub select in this case, if you want the summary data from the select statement you made;

something like this should give you the idea:

SELECT Location_1...

there's a difference between actual space used, and max space;

this script i'm pasting below will give you the actual space used;

go

/*******************************************************************************

  Written By  : Simon Sabin

  Date        :...

several things you can do:

change your default timeouts: the default is 30 seconds.

dim Conn as adodb.Connection

Conn .CommandTimeout = 300 'seconds=5minutes

Conn .ConnectionTimeout = 300 'seconds=5minutes

next i would suggest changing your statement...

Cory that info you provided was neat;

here's an example of what happens with that date:

create table #test(id int identity,dt datetime)

insert into #test(dt) values('12/11/9999')

insert into #test(dt) values('12/11/9999 23:59:59')

insert into #test(dt) values('12/11/9999...

you must change the collation for each column in the database that is char,varchar,etc.

simply changing the collation of the database DOES NOT affect the existing schema. to prove it, do...

wouldn't it be true that if you are using a CHAR field instead of a VARCHAR field, the string would be padded with spaces?

create table #test(charid char(20) primary key, notes...

are these cursors nested within each other?, it might be your issue is you are using @@fetch_status as the bailout condition for all 3 nested loops; as soon as one of...

here's a solution that creates the statements in FK hierarchy order by using one of the sp_ms procs;

note that I know it is not 100% perfect; if the database has...

i know the default UDP port is 1434, but could not find it anywhere in my registry;

i've pasted a script below that finds the TCPIP ports being used, but i...

the public role is sufficient to give the user access to create the DDL for any table/view/proc;

I just created a new user and gave them the public role to a...