Steve Hendricks (9/28/2012)

---

In re: "it's the selectivity of the data that is what the SQL engine uses to determine whether to use an index or not."

For SELECTs that would be...

I'm pretty sure the settings are stored in the

%appdata%\Microsoft\SQL Server Management Studio\11.0 folder in the SQLStudio.bin file.

If you use any applications that clear out temporary files to recover some...

ouch, there is seriously no "easy" way on this then.

to the best...

blindly adding an index on all the columns that foreign keys are involved with might not help much;

it's the selectivity of the data that is what the SQL engine uses...

well, like Ron/bitbucket said; there's many formats to an EDI file; somewhere someone on your side should have put together a document mapping out each element;

once you have that...

why to a text file, and not a table in say, the msdb database, which can contain a suite of commands for you to run during you rmaintenance window?

why must...

wedgemail (9/28/2012)

---

I dont think Im being clear

I know how to get it to run(add a linked server) but my question is how can

this code run successfully:

SELECT 1

FROM EWH_Staging.dbo.STAGE_REMP_VCC_Distinct vcc

It...

formatted a bit for readability;

similar to some EDI files I handle, it looks like the tilde(~) is the delimiter for message segments;

the ISA segment is a control header for "who...

tauseef.jan (9/28/2012)

---

Thanks guys, especially Lowell for the code snippet.

Actually I need, when a user creates/restores a database on the server

he should be automatically be assigned to db_owner role.

...

in that case, being on a remote server, you need a linked server so you can get to it.

and the...

tauseef.jan (9/27/2012)

---

hi friends,

I need to create a server trigger to automatically map a login to a new database and make it a member of the db_owner database role.

I was trying...

Well. Remember that the sql security model is deny by default;

Its easy to forget that as a developer since you test as sa/sysadmin.

That means you can create a view and...

i think in addition to a DDL trigger, you want to change the default paths as well;

a simple CREATE DATABASE SANDBOX' command doesn't specify the path, so unless you changed...

a case can't due logic...it must return a single value; you are trying to use it more like an If statement to get NextReviewDate < getDate() for example.

i think it's...

chrisph (9/25/2012)

---

I changed the names for the example but I tried the command with exactly the same database and table name that reside on the server. The user I...