kwoznica (11/23/2012)

---

OPC,

How could I expand on this so that if a login is not in the login table then the login is allowed. Right now if a login is...

No problem. I understood all your comments. Thank you for posting back. I look forward to hearing more as you work towards a solution.

The error you posted originally points to a VAS issue. The fact that only lesser-privilege users experience the issue could mean the Teradata driver is reporting misleading errors or that...

Jeff Moden (11/22/2012)

---

opc.three (11/22/2012)

---

The ideal situation would be to begin refactoring your way out of using xp_cmdshell so you can eventually disable it. You could start leveraging the SSISDB available...

The number 10000 sounds arbitrary enough to be a setting built into a third-party backup software (which is why I asked), a firewall or some other network-point like a router...

Having to maintain databases with a compat level of 80 has been bothersome to me in the past because some of my DBA scripts will not run against those databases...

Hughesy (11/6/2012)

---

Hi

I have a SSIS Package developed in 2008 R2 BIDS environment that includes a process task to execute a SQL script against a target database on a remote server...

Depending on whether my assumptions about your setup are correct there is actually a way to handle this in SSIS that works quite well and may save you what sounds...

ziako (11/15/2012)

---

Thanks for your suggestions. I do need the field. Its just the field may not be included in some daily files. How would i use the script task editor...

Please read this article. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

At minimum, please post DDL for all involved tables including the indexes and an actual execution plan for the query.

Have you see this utility proc MVP Adam Machanic produced for the community? Not only is it a replacement for sp_who but it's a great tool to learn more about...

The ideal situation would be to begin refactoring your way out of using xp_cmdshell so you can eventually disable it. You could start leveraging the SSISDB available as part of...

yuvipoy (11/21/2012)

---

SQL Server can only be installed on a Microsoft Operating system, so you'd have to create a virtual environment in Linux running , say Windows XP, and then install...

The only thing I see you are missing is the check for is_default. If you have any other traces running on the instance you may be picking up that one....

dave-L (11/21/2012)

---

Our web-based app exposes these IDs in the URL. Although their is additional security checking when executing queries based on the passed in URL UUID, in our shop...