Without blowing away my existing configurations, I'd have to guess here: but it seems logical to me that you would need to be a sysadmin to be able to setup,...

DECLARE @commandtext varchar(2000)

SET @commandtext = 'this

is

my

multiline

command'

exec sp_add_jobstep @command = @commandtext, ...

Set your import to use the '~' as the column delimter and '*<cr>' as your row delimter. By default it will be thinking the row delimter is a <cr> or...

I've had the problem too. I workaround it by selecting my answer and copy-to-clipboard before hitting submit. That way if something goes wrong, I can refresh the original post and...

1. Make sure you are using a datetime data type and not a smalldatetime, because "1853/01/01" and "1753/01/01" are outside the range smalldatetime supports.

2. Depending on your...

Microsoft have a support article on this:

PRB: System Database Backups Cannot be Restored on a Different Build of SQL Server

http://support.microsoft.com/default.aspx?kbid=264474

DBCC SHRINKDATABASE does not show it's progress, and how quick it will go depends on how much data needs to be moved, the speed of your server, and whatelse it's...

Taking a guess your app code  may have been

EXECUTE mySproc1

and your sproc may have been something like

create mySproc1

as

   BEGIN TRAN

     Insert something ...

GO -- end of mySproc1

If this was...

Stick with one datetime data typed column. Your GUI / Client Program should be responsible for enforcing that a date and time be entered. Just turn off NULLS in the...

True. TRUNCATE TABLE does not shrink the size of the physcial database files on disk. It also doesn't cause your transaction log to unnecessarily grow like a DELETE Table will.

There...

Take a look at Roles based security in BOL. You may want to create a developers role, or you can use the existing ones.

If you add someone to the db_ddladmin...

Definately use a temp table, import the txt file to the temp table, and manipulate your data there, then just copy it out to where you need it at the...

I wish... I've had to deal with a number of databases that had an initial / minimum size specified too high.

to quote from BOL:

The target size for data and log...

IS your SQL Server starved of memory? or is it starving the OS of memory?

In Enterprise Manager, right click your server, choose properties, and hit the Memory tab. Keep...

Randy

Try these simple steps:

-- Ask SQL Server to update and display file usage

EXEC sp_spaceused @updateusage= 'TRUE'

-- Get SQL Server to DEFRAG the data inside the files,

-- and then...