Read and implement the sample code listed in the following links.

BEGIN TRANSACTION ...http://technet.microsoft.com/en-us/library/ms188929.aspx

Within the TRY block

T-SQL block...http://technet.microsoft.com/en-us/library/ms175976(SQL.90).aspx

Within the CATCH block

ROLLBACK TRANSACTION ....http://technet.microsoft.com/en-us/library/ms181299.aspx

No error

COMMIT...

I would suggest that you read in the area of Sociology (foreign to most, if not all techies) in particular "small group theory". It will illustrate how and why...

As stated by others:

Thanks for a thought provoking / learning experience keep up the good work.

Sankar...

khurramsaifi

Your code works well with a file path such as:

set @filepath = 'dir C:\dj5551\*.exe /-C '

but with a file path that contains blanks no data is returned

for example":

set @filepath...

Use http://technet.microsoft.com/en-us/default.aspx

In the input box type: "upsizing access to sql server" it will return some 650 links to articles, scripts, blog postings that discuss this question. If you can...

Nice question ....

hrvoje.piasevoli

Excellent bit of code ..... Hope...

Have you looked at the sp_help_fulltext_catalogs procedure .. you could couple that with the undocumented sp_msforeachtable and that may give you some assistance

WayneS

I've been contemplating making a presentation to the UG based on the Comparing Table Variables with Temporary Tables article that I wrote last year - do you'll think that...

Assuming I read and properly understood your explanation.

CREATE TABLE #T(ClientOrderNumber VARCHAR(10), ItemCode VARCHAR(10),QTY INT, DWeek DATETIME,SWeek DATETIME)

INSERT INTO #T

SELECT '7808','7765',100,NULL, GETDATE() + 10 UNION ALL

SELECT NULL,'123',1000,NULL, NULL UNION ALL

SELECT NULL,'7765',100,NULL,...

Dfalir

The order contains a variety of data to be completed, but i beleive that the most important data that is to be used for the "checking algorithmin", are the...

You may want to start by reading these articles

http://www.sqlservercentral.com/articles/Career/61243/

http://www.sqlservercentral.com/articles/DBA/67706/

http://www.sqlservercentral.com/articles/Database+Weekly/69108/

scott.pletcher

CREATE TABLE #T(Id INT,Date1 DATETIME,Date2 DATETIME)

INSERT INTO #T

SELECT 1,'2/1/2007','1/31/2010' UNION ALL

SELECT 2,'2/1/2007','2/1/2010' UNION ALL

SELECT 3, '2/1/2007','1/15/2010'

SELECT Id, Date1 AS 'Start', Date2 AS 'End', DATEDIFF(YEAR, date1, date2)

+ CASE WHEN CONVERT(CHAR(5), date1,...

Phil Factor

This is why I like to use ASK SQL Server Central as well. Here is a medium that allows more freedom to float ideas, to comment on replies, to...

This article explains how to use a T-SQL script in conjunction with Windows Task Scheduler to automate backups of you SQL Server Express databases on a scheduled basis.

http://support.microsoft.com/kb/2019698