Mario,

Is that the entire error message?

Jimmy,

When you generate scripts, there is an option to "Script Database Create". It is set to False by default. If you set it to True, then it will include the...

Bhavesh, are you sure, you can only store a max of 8000 characters in varchar(max)? Please try and confirm. I dont think that is right. If it can only store...

I tried it in SQL Server 2008.

I just created a sample stored procedure to find out. It takes an input parameter of varchar(max). And the stored procedure is returning the...

My recommendation would be:

1. Create a database role or as many roles you will need.

2. Assign appropriate permissions to this role

3. Assign the users to the database role you have...

Just curious, why are you trying to append all the column names into a variable?

Thanks

Please start a new question on a new post. This thread has ended last year March, 2009

Check this article out. It shows how to use opendatasource() function against text files. I cannot test this as I am running 64bit SQL Server 2008 and it has some...

Are you sure, the user understands that? Its odd that you don't to move the data.

Also, in SQL Server when you script the database structure, you can use it to...

Do you get the results back if you run this simple query?

select count(*) from sysindexes

Another question is, what are you looking for in the output? If you just want rows affected and such, Lutz suggestion will probably work better.

Off the top of my head, one way to get the message output would be to use osql command line utility where you can the SQL script as an input...

Excellent Point.

Did you check the account SQL Server Agent is running under? Hopefully you have already checked that.

I had a related issue where the jobs stopped running and found out someone...

Are you doing this manually or is it part of a script and you have it scheduled in SQL Server Agent?