I haven't experienced this issue, but have you considered creating the view with the SCHEMABINDING option? Here's the notes from BOL (http://msdn.microsoft.com/en-us/library/ms187821(v=sql.90).aspx)

If a view is not created...

I think the problem is with the line that specifies the rowterminator. After I duplicated the error you got, I simply removed the rowterminator specification. ...

Is \\192.168.14.25\d$ the exact value you're typing in for the expression? If so, I think the issue is that the backslash in SSIS is used as the escape...

A totally reasonable and useful request. Unfortunately, I don't believe there's a way to do exactly what you're describing. I've tried to do this...

Is creating a mapped drive an option in your environment ?

If you haven't already done so, I'd recommend some basic checks

(1) Verify that the code is actually connecting to SQL Server. Have you tried stepping through the...

Actually, it doesn't look like SQL Server needs to be shut down. The tool just reads from master.mdf directly

Brian Kukowski (4/13/2011)

---

You might want to check out the 'Advanced...

You might want to check out the 'Advanced SQL Password Recovery' product by Elcomsoft. I don't have experience with this tool, but Denny Cherry mentioned it in...

The methods mentioned for capturing stored procedure usage are definitely good. Whenever you decide to remove the stored procedures, you might consider first making a backup copy of...

It looks like Microsoft has been aware of this issue for awhile...

http://connect.microsoft.com/SQLServer/feedback/details/467582/db-ddladmin-role-doesnt-allow-use-of-design-functions-in-ssms]

Brian

You might want to check out the following free tool from SQL Sentry

http://www.sqlsentry.com/plan-explorer/sql-server-query-view.asp

Brian

'SELECT *' pretty much guarantees that SQL Server won't be able to take advantage of a potential covering index...

Great topic. Something I give a lot of thought to, and always looking for new ideas. In many ways, I think my responsibilities consist in...

Security is the first thing that comes to mind...

- Absolutely no use of the sa account, except for emergency purposes. I include myself in this restriction. ...

For me, the use of "profane" features comes down to a question of risk/benefit analysis. Will the benefits of using a feature overcome the potential risks? The...