From what I have read the Server Proxy applies only to xp_cmdshell but the documentation is in lack of clarity in terms of whether the proxy also pertains to external...

Here...

Upon looking some more, ordering may not be your issue if the blank line in between the header and rest of the file is showing properly. I am thinking the...

You may be running into an ordering issue with bcp. Order is not guaranteed without an ORDER BY. See if something along these lines will work for you:

CREATE TABLE test(test_id...

That is one possibility if the query or table has only a single column and the file is defined as delimited. While NULL may amount to no value going to...

Can you please provide repro code including CREATE TABLE, INSERT statements to populate table and complete bcp command being used?

Thanks for all the replies!

I appreciate the insight into what others are doing. I think I would prefer to use SCOM but it's not available in the current shop unfortunately....

Good call, I didn't think to ask about the server proxy. It is worth checking in the instance as it could be the root cause of the behavior. By default...

eclispe66 (10/30/2012)

---

Hi opc.three I will review the link you sent thanks. So far nothing I have tried has worked. I asked our IS to look into it but I have...

sqlnaive (10/30/2012)

---

Suppose there is a tableA and trigger defined for Insert, Update and delete to populate audit table say tableB. Now If i want to give a user U1 write...

Yes, Evaluation to Standard is a supported upgrade path.

Upgrade to a Different Edition of SQL Server 2012 (Setup)

If updating the key then if required SQL Server will move the record to the correct partition per the answer to the partition function. It does this by deleting the...

When you setup the DSN which ODBC driver are you using? ODBC connections can be pooled meaning the connection will not be destroyed after every query. If you're not using...

Here is the list of what each Server Role can do:

Permissions of Fixed Server Roles (2008 R2)

serveradmin can only do these things: ALTER ANY ENDPOINT, ALTER RESOURCES, ALTER SERVER STATE,...

Instead of using EXECUTE AS LOGIN = in the proc that creates the Linked Server and granting impersonation rights to your user base for that LOGIN you can try using...