The package is a binary object. It is stored as such. If you want the package documented internally, add an Active X task, and type in the documentation as a...

You can use DATEDIFF to calculate time intervals. Look it up in BOL for the parameters for minutes and ordering of the dates.

You could use an insert select() where your...

May work differently in SQL Server 2005. Sorry, in the middle of a workstation switch and ss2k5 isnt set up yet

You might be...

How are you doing the restore? Through EM or isql/osql or QA? EM opens multiple connections. The QA Object Browser opens a separate connection.

Not the max . Might be less for some editions, but the max is the max for all versions.

More things. Check AWE/PAE and be sure they are the same. I bet they are since you mention comparing configs, but double check.

2nd, was this a backup/restore? Did you rebuild...

check your dateformat so you know which day is which. For example, for me in the US, Sunday is 1.

The previous Friday is simple math. So for today, I subtract...

I'm not sure I'm understanding. Are you dropping the results from DBCC INPUTBUFFER into another table? And then are you trying to update something else? Maybe you could give more...

Or this:

drop table MyTable

create table MyTable

( myid int

)

go

insert mytable select 1

insert mytable select 10

insert mytable select 12

insert mytable select 17

insert mytable select 21

select a.MyID

, (b.myid - a.myid - 1) 'blanks'

...

You set it by connection, not by user ID. The connection from the client can send a timeout message to a server after xx seconds.

SQL Server reuses space if data is removed.

A couple things to check. First are you sure the data file is growing and not the log file? Some people use the...

sp_configure 'allow_updates', 1

go

reconfigure with override

go

update sysusers

set name = 'MyNewRole'

where name = 'MyRole'

go

sp_configure 'allow_updates', 0

go

reconfigure with override

This help?

http://www.sqlservercentral.com/columnists/fBROUARD/recursivequeriesinsql1999andsqlserver2005.asp

Shouldn't the first one be "server"

Try here: http://www.connectionstrings.com/?carrier=sqlserver2005

We're digging in. It has to be something with the forum software. All the other dates in ASP and on other sites are working in US format. Servers are set...