I seem to remember that you need to change the acount from the SQL Server Configuration Manager. I think it was related to the Server Master Key not being...

You aren't going to like it..

1. Create a new table with the fields in the order you want

2. Copy data from old table to new

3. Drop old table

4. rename new...

Then I guess I would chose an account and send the credentials for it..

CEWII

You are very welcome, most of these questions I see are directly related to variable scope. I'm glad I could help.

CEWII

I didn't think you could write extended stored procedures in .Net.. Maybe it was just you coldn't do it in C# or VB..

CEWII

Jack Corbett (7/31/2009)

I'm pretty sure that it is...

SQL 2008 Licensing Page:

http://www.microsoft.com/sqlserver/2008/en/us/licensing.aspx

SQL 2008 Express Page:

http://www.microsoft.com/sqlserver/2008/en/us/express.aspx

From the Express Page:

Limitations

SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage

I'm not sure if that is 4GB per...

The only thing that comes to mind is a view..

CEWII

I can't speak for others but in many cases they are interchangeable. In cases where a set if being evaluated only a CASE statement can be used, in cases...

I don't believe you have any options on this, I think you will need your constraint. Also, I think you really only need the FieldName != '' constraint. ...

I think you are discussing Variable Scope. A variable can be created at the package level and at basically any sub-level. A package configuration can manipulate package variables...

I'm not a 100% sure but I think it follows the login of the user calling it, but we would need to know whether there was an EXECUTE AS on...

I hate it when that happens..

CEWII

I'm not sure you can accomplish this with SQL 7 or 2000, in SQL 2008 you can using a LOGON trigger and you could probably trace it using sp_trace_create in...

Great, glad to hear it..

CEWII