I would recommend to make one file with all scripts and then do a search and replace otherwise you will have to convert all statements to string and Use...

You have to use a static table not a temp table if you want to use EXECUTE()

Execute func does not see temporary table neither local or global.

And I do not...

Can you post complete CREATE PROC Scipt

nor just the table name.

quote:

---

Here it is. The name of the temp table is...

You can use

BACKUP LOG [dbname] WITH TRUNCATE_ONLY

thou i would reccomend to backup the log too, in case you need to restore your data in the middle of the day.

Can you post your Script it's kind of hard to tell without seeing it.

At least for this type of error.

quote:

---

I have a...

BACKUP LOG [dbname] WITH TRUNCATE_ONLY

I would reccomend to actually back up the file before you truncate it.

quote:

---

Hi guys!

Can you help me to...

If you just want to sort the column order then use Antares686' example, if you want to rewite the table structure.

You have to move everything into a temp table...

Change your SQL Server Agent service to use NT Domain account.

quote:

---

SQL Server agent currently uses the system account, which caouses...

I appologise made a typo, the only time you would use double colon is when you are calling a system table function like this.

select * from ::fn_helpcollations()

May 15, 2002 at 8:23 am

#429190