In a script component, do something like this (untested): -

DirectoryInfo directory = new DirectoryInfo("T:\\Test");

...

All I can say to that is "it depends". I purposely...

simon.crick (10/7/2013)

---

I will probably get shot down again for saying this, but I believe people should stick to core technology and basic tecnhiques unless there is a very good reason...

I think of myself as a beginner. I've been working with SQL Server for almost 4 years and generally move on to a new job as soon as I...

Got to agree, the logic isn't quite right for the outer apply method. The below uses a sproc written by Jeff Moden for generating a...

--SAMPLE DATA

--NOTE: IF YOU LAY OUT YOUR SAMPLE DATA LIKE THIS, PEOPLE ARE MORE LIKELY TO HELP YOU!

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN;

DROP TABLE #testEnvironment;

END;

SELECT subjectid, subjectname,...

When you post in multiple threads like this, you fragment answers and make people have to start from the beginning again with helping you. If you have further questions, stick...

I'm not sure how many times I have to say "SQL Injection" to you. . . yes you...

andrew gothard (9/27/2013)

---

Can anyone - off the top of their heads - think of a way of preventing backups being taken to the C:\ drive?

I've run a very quick google...

SELECT TOP 5 ID, MID, RName, Pic1, FoodType, Average_P_PP, lat, lng, Distance

FROM (

SELECT ID, MID, RName, Pic1, FoodType.Descr AS FoodType, Average_P_PP, lat, lng, Zoom, MAct, (

...

enriquezreyjoseph (9/27/2013)

---

Cadavre (9/27/2013)

---

You're also vulnerable to SQL injection. Please look over the code...

You're also vulnerable to SQL injection. Please look over the code I posted...

Why not build up your WHERE clause like this?

ALTER PROCEDURE [dbo].[SearchBiography] @firstname NVARCHAR(50), @middlename NVARCHAR(50), @lastname NVARCHAR(50), @sexID NCHAR(1), @statusID NCHAR(1) AS

BEGIN;

SET NOCOUNT ON;

...

Have a read of this article --> http://www.sqlservercentral.com/articles/T-SQL/61539/%5B/url%5D

Cadavre (9/24/2013)

---

One of these queries may help.

--== Locks held in database ==--

SELECT request_session_id AS [spid], DB_NAME(resource_database_id) AS [dbname],

CASE WHEN resource_type = 'OBJECT' THEN OBJECT_NAME(resource_associated_entity_id)

WHEN...