I hope that I'm not giving bad information but I always encourage testing connection issues from SQL to rule it out.

If you go into SSMS you can expand Security at...

Try creating in a Test Database.

I removed the Database Name Qualifier from the column name that you are getting the error?

--USE [TrailerManagement]

--GO

/****** Object: Table [dbo].[UserProfileDetails] Script...

Issue the command to determine who is connected to the database.

Then you will need to Kill the connections to the Database.

Make sure that you are not connected to the Database...

I did not get the error either and I have converted a lot of Access Databases to SQL Server.

I hope that these help:

http://www.dbforums.com/microsoft-sql-server/992581-select-data-temp-table-sql.html

http://stackoverflow.com/questions/61967/is-there-a-way-to-loop-through-a-table-variable-in-tsql-without-using-a-cursor

http://vijaybalajithecitizen.blogspot.com/2008/08/table-variable-and-temp-tables-in-sql.html

Can you expand on this?

It appears that you are removing the first group of records...

I don't think this is what you need. I searched quite a bit:

http://blogs.msdn.com/sqlpbm/

If I understand you question I believe that you could use the Substring Function and the Concatenation Operator to achieve the desired results.

I assume that you specified the correct Database ID and that there is not a leading or trailing space embedded in the Database ID Filter?

What happens if you remove the...

----------------------------------------------------------------------------------

Elliott W

I have done it with SQLCLR and in script in SSIS.

I met the guy who wrote it and shook his hand.. Love it! It even uses service broker..:cool:

----------------------------------------------------------------------------------

Elliot, would...

Hi,

I should have mentioned that SQL Mail and those Extended Stored Procedures are depreciated and they require the use of MAPI.

In SQL Server 2000 & prior I used an...

Is you Account a Member of the SysAdmin Fixed Server Role or DBOwner or DBReader Database Roles on your machine? I would not recommend this when you promote this to...

Thank you for your contribution. 🙂

I don't typically use a view for it is just a catalogued SQL Statement.

Why not use the SQL Statement as the source and the base table as the destination?

Are you...

Apparently copy only backups are not supported or there have at least been reported bugs and issues in SSMS.

I got several hits on this issue yesterday before I knew that...