Paul

Here's a solution that doesn't use a numbers table.  It will work in your situation but it may be fairly difficult to generalise!

First off, I assume you have a constraint...

Jeff

This (and other similar threads) seems to suggest that there is logging in tempdb.  Don't know whether there's anything from Microsoft confirming this.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=13898&p=2

John

I'm not sure that this is the neatest or easiest way of doing it, but it should work:

(1) Using Enterprise Manager, create a job called something like "Event Notification 322"

(2)...

Sandesh

Try putting an N in front of all quoted text.  Make sure that all variables have been declared as nvarchar.  And get rid of those unnecessary qualifiers - that will...

Jonathan

Check the properties of the task and make sure you're not copying any users or logins.  It sounds as if SQL Server is having difficulty copying a user or login...

I don't understand what you're asking.  You can see the restored database under Databases in Enterprise Manager (you may need to refresh) and you can see the backup file in...

(1) If the database already exists on the destination server, make sure that nobody is using it and then right-click on it in Enterprise Manager.  Otherwise, right-click on Databases.

(2) Choose...

Sandesh

Again, have your SP print the SQL it's going to execute.  It'll be a lot easier to debug that way.

You don't need to qualify every mention of a column with...

This should do it:

select b.close_price, b.date, c.avg, c.year

 from tenyearbond b

 inner join cpi c

 on datepart(year

You have a lot of dynamic SQL in that stored procedure.  For troubleshooting purposes, try adding a PRINT statement before every EXEC statement so that the SQL that is about...

David

Not sure exactly what you're asking for, but here's a guess:

insert into MyDB.dbo.Abs (Tpc, Prp, Frwk, Fndgs, Title, Mthds)

select Tpc, Prp, Frwk, Fndgs, Title, Mthds from BackupDB.dbo.Abs

John

Rodney

That's right.  If you don't want that, then the only thing I can think of is to create a job that checks for objects not owned by dbo and changes...

Biju

It looks as if the data impiort process uses temp tables.  You need to expand your tempdb so that it can accommodate all the necessary objects.  Right-click on tempdb in...

Have you looked at creating a DTS package?  You can copy tables, users and other objects from one database to another.

John

Rodney

I take it you have added him the the db_ddladmin database role?  All you need to do is have him create tables as follows:

create table dbo.NewTable (<column spec&gt