or .... if you're allowed to do so during your update ... put your db in simple logging ...

Keep in mind..... backup before, symple recovery, your stuff in batches, full...

if sqlagent is not activated you may not see sqlagent stuff.

you can use sp_configure to still have all sqlagent stuff visible.

-- enable Agent XPs

EXEC sp_configure 'Agent XPs','1'

RECONFIGURE

GO

You may need restart sqlagent to activate the first alert !

for the rest: It does not know a individual address from a group address

nailosuper (10/23/2008)

---

Yes i looked. I didn't find something so different. Here's what i saw :

BackupMedium::ReportIoError: write failure on backup device '\\XX.bak'. Operating system error 1130(error not found).

any ideas ?...

Keep in mind that the "-i" file needs to be available at the server or client where you actually launch the SQLCMD (or osql) !!

edit

this also goes for the -o...

Very nice presentation indeed :w00t:

Hey...

varchar(max) is only available as from SQL2005 !

However, you can concatenate variables to execute with exec.

Here's a little example:.

EXEC (@SQLQry + @SQLQryp1 + @SQLQryp2 + @SQLQryp3 + @SQLQrypx)

Indeed, service broker is a bit hard to monitor and to figure out what's going on.

You really need to play with it, to get the grips.

Here's an overview of my...

Just another flash in the brain ..... or what's left of it;)

When you switched the NICs, did you rename the NIC ?

We tend to use "public network connection" for our...

Forget about AWE for x64 ! Thats what it's all about with 64-bit.

You don't need that unless you go over the standard 64-bit addressing window.

However, you need to set your...

Oh indeed... I did forget to mention that !

- sqlinjection risk

- if the formula contains an error .... try to figure it out.

Be aware it may start with numeric info...

Programming basics : copy/paste 😀

DBA basics: script programming :hehe:

In fact, Jacks solution is better, except for the isnull testing.

There it depends if your columns are allowed to contain nulls or not.

And you should still perform :

if @@ROWCOUNT =...

you should directly move the data into your varriables:

ALTER PROCEDURE [dbo].[getSchedule]

-- Input

@facility char(2),

...

did you try this ?

Declare @weight as char(25)

Declare @output as numeric(18,2)

SET @weight = '2*5+2*5*4'

declare @TheSQL nvarchar(1000)

Set @TheSQL = 'Select @theoutput = ' + @weight

--OutPut should be 50.

exec sp_executesql @stmt =...