Just for grins, next time try charindex to find the first occurence of a period in the field - update field set field = left(field,charindex('.',field)-1)...

Joe

One quick comment on taking a snapshot of the production database for use on dev/qa:  Since the developers (and maybe DBA's) are in the middle of making modifications to their...

What O/S (e.g. Windows 2003 32-bit) and version of SQL Server (e.g. Standard X64) are you running?

Joe

A little bit of research indicates that there are multiple ways for these proc's which are related to database diagramming to get created - Visual Studio, SSMS, Enterprise Manager, etc....

If it's half dozen of one and six of the other I would definitely take a look at C# vs. C++ - C# was pretty much built from the ground...

dt_ procs are typically created by Visual Studio or other development tools... not really a problem assuming that you're working in an environment where developers are supposed to have access...

db_datareader would be a good start - would at least give your developers read only access to all the data.  In sql 2005 you can also allow the user the...

Ian -

Check the permissions on the stored procedure - does the login being use from asp have execute permissions on the stored procedure?

Joe

You can also install the backwards compatibility tools for SQL 2005 that will allow your DTS packages to run within SQL 2005...

Joe

Reporting services + report model(s) is definitely the way to go if cost is a factor.  You may want to see if you can use the SQL 2005 version of...

Good guess/plan, I'd check fragmentation on each the of servers for sure.

Just out of curiosity why would you want to not include a header record?

Just one comment/thought, be careful if you start futzing with the order of columns in a table if you're not absolutely certain that your client side code is not using...

When you say you're seeing a network I/O wait, where are you seeing that, within SQL Server or via perfmon?

On a machine here in the office I can't find a...

Dazza -

Try an alias for your linked server.  In a quick test I was able to create an alias, then a linked server pointed at "Server A" using the alias, no...