SQL Kiwi (1/11/2012)

---

:laugh: But seriously, the example code did not specify NOT NULL as...

Thanks Gail and Paul. I always learn something when y'all post.

Oh, and as far as inserting a NULL code, you shouldn't have NULL's:-P

SQL Kiwi (1/11/2012)

---

None of them for the reasons already stated, plus option 2 also contains a race condition.

DECLARE @MYCODE int = NULL

DECLARE @ID int = NULL

DECLARE @OUTPUT TABLE (ID int)

MERGE...

Dev (1/11/2012)

---

If somebody can login to Application Server & read configuration files, he can delete website as well (worst scenario).

SQL Server Logins are manageable for Web Applications. Few...

Little Nick (1/11/2012)

---

RESOURCE_SEMAPHORE_QUERY_COMPILE waits is high. My understanding, this nothing to do with my ASP.NET code technique

Let's, my same Stored Procedure is execute 500 a day. Did we have special...

GilaMonster (1/11/2012)

---

Jack Corbett (1/11/2012)

---

How about option 4:

Declare @ids Table (id INT);

IF NOT EXISTS (SELECT * FROM myTable WHERE CODE=@MYCODE)

BEGIN

INSERT INTO myTable (CODE)

...

You can't write directly to a table with a server-side trace. Even if you could it wouldn't be wise as it would not perform as well as writing to...

How about option 4:

Declare @ids Table (id INT);

IF NOT EXISTS (SELECT * FROM myTable WHERE CODE=@MYCODE)

BEGIN

INSERT INTO myTable (CODE)

OUTPUT Inserted.id into @ids

...

Dev (1/11/2012)

---

I don’t prefer Windows Authentication based database servers for Web Application. It’s better if user login with Application (Web) Login Name and Application Server translate its credentials...

AER (1/11/2012)

---

Jack,

Thank you so muck for your help. I totally agree that the Windows Authentication is the most secure way of handling the application pools.

Now since I'm more on SQL...

Little Nick (1/11/2012)

---

My current code as following,

Dim sqlNm As String = ""

Dim sqlNm2 As String = ""

...

Normally with SSIS you would do this using SSIS configurations or by setting a variable value using the command line options. Here are a couple of resources:

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx

http://msdn.microsoft.com/en-us/library/cc895212.aspx

You don't want to shrink and that won't fix the issue if all the space in the file is used. If you have drive space you should grow the...

You haven't provided enough information for anyone to provide an accurate answer.

What do you want the view to provide? A union of the results from the tables...

Yes you select the top option and then you just select install client tools.