rajkiran.panchagiri (11/22/2012)

---

In our servers, Server team don't allow us to use Powershell. We have only limited access.

That's quite interesting, is there a reason that they don't allow powershell as this...

Done a bit more digging and come up with an answer: "the maximum size for a column that is included in a unique constraint is NVARCHAR(450) or 900 bytes."

That makes...

Quite right, apologies - got carried away,...

If you try 'DBCC OPENTRAN' it may indicate that your oldest active transaction is a replicated one which has been open for a while, this could potentially be your problem....

Hi Bob,

It sounds like the problem could be connected to the mapping between the DB user and the login, have you tried "ALTER USER [your user name] with LOGIN =...

Hi, read this question with interest and was wondering if a copy only backup from your PROD server restored to your UAT server would do the job seeing as you...

Many thanks for the suggestions.

SQLBits is definately on my list for next year as is SQL in the City.

ChrisM@Work - I'm trying to get myself up to Manchester for...

Agreed

After the research I did and my subsequent recommendations, my company are now looking at a completely different method of integration and we're ditching Jitterbit!

Thanks for your response.

I was quite lucky when I came on board with my employer as they basically said that I could spec my own laptop prior to me starting (providing it was...

Mark Eckeard (8/8/2012)

---

Do you mean a front-end to manage the SQL Server itself or an application front-end that uses SQL Server as the database?

If the latter, we use mostly .net...

Huge thanks to everyone who's reply to my post, there's been some great ideas that I'm going to put into place and use which should keep me out of trouble...