Did you check for DENY on that table? What does this return?

DECLARE @schema_name SYSNAME,

@table_name SYSNAME ;

SELECT @schema_name = 'schema_name',

...

In the scenario where SQL Express is leveraged to create an on-demand file loader and archiving application SQL Server...

Evil Kraig F (10/5/2011)

---

opc.three (10/5/2011)

---

Evil Kraig F (10/5/2011)

---

SQL Express with an on-demand file bulk...

Cool, happy you got it sorted!

My guess...

I would consider myself a crusader against enabling and using xp_cmdshell. I have posted many times on these forums advising against the use of it. All too often it is...

I have just one tweak. backup_size is...

SSIS may be the fastest performer but if you're not versed in it you can use bcp. It is quite fast when using Native format between two SQL Servers. You...

awu (10/4/2011)

---

Put service account as local admin group will save lots of permission issue , so. wondering besides security concern, what else is really the big problem...

peterjonk (10/3/2011)

---

Thanks for your reply. Yes this could be a metadata sync problem, but I already tried refreshing the SSIS metadata.

The problem occurs in the validation phase of the data...

Nice work. Thanks for sharing that.

This may save you a bit of time down the line. You can add hooks to the PowerShell runtime directly into your SSIS environment enabling...

If you look at the code for sys.sp_helpsubscription you'll notice it calls two procs, sys.sp_MSrepl_getpublisherinfo and sys.sp_MSrepl_helpsubscription. Chances are the proc sys.sp_MSrepl_getpublisherinfo does not make use of INSERT EXEC...

I am not sure why you are not having the issue when you run as a login/user in the db_owner role. Regardless, if you are getting by with a db_owner...

You are superb Gail, thank you for your help here 🙂

GilaMonster (9/27/2011)

---

Updates to a heap cause forwarding pointers, which is far more a problem than extent fragmentation and would probably...

GilaMonster (9/27/2011)

---

opc.three (9/27/2011)

---

In a write-heavy system with lots of updates to variable-length columns (inner-table page splits) and queries producing table scans heap fragmentation can play a bigger role in performance...