Thanks guys. It's one of those things where you "feel" like there is a way to do it. I will try these and give it a whirl and let you...

Yeah, I've spent today trying to get some data for my dev system. The trouble is the database this sits in, is around 200gb in size which is far bigger...

I don't have a created date, that's the problem. In the audit table a record gets entered to say "customer created" and there is a date stamp on that, but...

• This reply was modified 5 years, 7 months ago by snert.

?I have a SQL job that copies data from 3 tables in one database into a second database, truncates the originals, and then refills them from somewhere else.

So, I have...

@sgmunson. Sadly it is an nvarchar as the system is designed to run in multiple languages and handles those with different character sets. The notes field is most likely to...

Well, trying to set this all up didn't quite work to plan. I ended up getting locked out of the server completely which was a bit of a bind.

So, could...

Hi,

Yes, the server is directly on the internet. I checked ipconfig and ther eisn't an internal IP range defined. I'll check to see if the data centre can apply one.

~L

Hi Lee,

If you are allowing remote access only to SQL Server Database on a Windows server with a 'sql login' have you tried these steps.

1) Identify IP address of your...

Yes, TCP is enabled

I fixed this in the end. In the data source properties I have changed it so that it doesn't rely on Windows Authentication rather it uses a SQL login. This...