There are no error messages returned, it's like if there was no configuration file. the package is using its stored configuration values and runs fine...

The user running the job in sql agent has access to the network location. The network location is the same where the package is stored.

Same here...where can I register?

Hi,

I also agree with the other writers. Use raw SQL statements or create 40 procedures.

If you decide to create the procedures have a look at the ssms toolpack => here

One...

No, there is no limit 😀

declare @sqlstr NVARCHAR(MAX)

SET @sqlstr = N'CREATE TABLE defaultTester ('

DECLARE @i int = 0

WHILE @i < 1024

BEGIN

SET @sqlstr = @sqlstr + 'col' + cast(@i...

AVB (5/25/2010)

---

I'm in the process of putting togther some DR stuff for my company. I'm considering DB Mirroring with automatic failover which seems pretty straight forward. The big question is:...

Hi calvo,

for an initial...

Hi,

yes that's what I expected or thought what would happen.

Do you know how this works internally? If it updates col2 to the value of col1 first and later col1 to...

Hi,

maybe a profiler trace can help to find out what the management studio is doing when it scripts out a job...just an idea 🙂

Hi,

I don't know how to override the default behavior. Maybe the BIDS Helpder can help you with the feature "fixed width columns".

http://bidshelper.codeplex.com/Wiki/View.aspx?title=Create%20Fixed%20Width%20Columns

Hi,

maybe this article can help you:

http://www.sqlservercentral.com/articles/SSRS+2005/66259/

Hi,

maybe this post (the last "update" at the end of the page) helps.

http://www.developerdotstar.com/community/node/338

Hi.

try

IF @variable = 1.

(one "=")

Hi,

have a look at this article MSDN

There you'll find an example how to use a check constraint with a function.

I hope this helps 🙂

Hi,

I think something like this should do the same, except for the userid...

--Edit: forget that...misunderstood your statement

I hope this helps 🙂