Ummm, maybe logically speaking, but not in terms of...

JQAllen (2/28/2012)

---

George,

In the first part of your post it sounds like you want to implement a simple recursive relationship, i.e., parent-child.

CREATE TABLE [Relation](

requisitionID [int] NOT NULL,

parentRequisitionId [int] NOT NULL,

CONSTRAINT [PK_Relation]

PRIMARY...

Some possible options:

- If you're just reading base tables in msdb in the dbo schema and not catalog or system views then can you create a stored procedure in msdb...

Regarding the use of TDE in general, there will be a performance hit for CPU so plan on it...and if you;re leveraging native backup compression to keep your backup sizes...

If you're serious about protecting "at rest" data in all scenarios including protecting the mdf and ldf should someone get access to the server's file system then TDE is the...

If you're accessing data using the table name then you have the option of renaming the table and replacing it with a view of the same name with the interface...

If all you need to do is execute a package then a single-line PowerShell script that calls dtexec.exe is all you need. e.g.

dtexec.exe /f "C:\UpsertData.dtsx"

See section "dtexec (SSIS Tool): Examples"...

All groups they belong to or the specific one...

Why are you trying to use PowerShell to execute SSIS packages? Why not use SQL Server Agent?

ducvancong (2/19/2012)

---

Hi !

I create application role and grant all permission in database for it . but , when I want create new login and user in my application,...

Jeff Moden (2/19/2012)

---

I agree that minimal logging <> no logging but it is very much reduced (miniscule, actually) from normal logging. And, although BULK INSERT won't do it, OPENROWSET...

Jeff Moden (2/18/2012)

---

opc.three (2/18/2012)

---

Your problem is a classic one that IMO is not elegantly solved in current versions of T-SQL. The window frames coming out in SQL Server 2012 may...

You are correct about each code solution's elegance, for...

I have a fair amount of...

I worked on this for a minute too. Since you're looking for subsequent lines to add value to your object's row it's back to that nasty loop logic...see if this...