Then, like I suggested before, I suggest creating a Firewall rule to block all access attempts to the server on port 1433 (or whatever port your SQL Server is running...

• This reply was modified 6 years, 6 months ago by Thom A.

No. What appears to be the case (I am not located on that site) is that the machines maintain a continuous connection (They are always looking for new instructions,...

So you';re saying that the machines in the network are connecting by sqlcmd? That sounds very unlikely, but if it is the case, also sounds like a very odd set...

Thanks Frederico. Yes - you are right, I want the file to be formatted to have certain properties . I am creating around 1000files so can’t do this individually....

format is for creating a format file, not for specifying the format (Arguments). If you want to specify that the file should be in a CSV, then you want...

I find it's better avoiding SSMS in single user mode. SSMS will open multiple connection initially to populate things like the object explorer, which can result in the single connection...

Key thing, don't make the CV look like a series of job descriptions.  Focus on accomplishments and if you have hard numbers such as: improved system performance by 30%,...

This is something I'm going to be...

Just a...

On the subject of questions getting worse, here's what it has finally come to.  Notice in the zip file that there is absolutely everything that one might need...

This is somewhat sweeping, but I think the biggest mistake you can make is making a mistake and then not admitting you made that mistake (and further more hiding it)....

It isn't just here that the questions are getting worse. If you look at other sites the same trend is true. Considering the wealth of knowledge that is readily available...

Likely because I mentioned you should have a varchar and...

I am intelligent and I have no varchar of 1 billion characters.

Also, in my designs, there is usually no place for varchar. In that case, I would use text...

You should actually have 2 different versions of this, one for nvarchar and another for varchar. A varchar over the length of 1billion~ characters would be truncated when it is...