the problem with this is what about all those forums you subscribe to to keep abreast of questions...I probably belong to a dozen different forums for various interests.

$108 ($9 x...

i poked around the MS KB, and wow they are purposefully vague on how to fix any underlying conditions that might raise error 18; i'm going to watch this thread...

why not just grant permission just to the specific procedure, instead of a role that has too many rights?

grant execute on pr_truncate_table to webdev

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...