You are not providing nearly enough info to enable us to effectively help you. Post the slow query, all table definitons (including indexes) for tables involved in the query and...

Great, you are back on track!

Theorically theres no backup full, because the recovery model was changed to simple, and full, an all lsn sequence not makes sense anymore.

Does it make...

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...