What you'll want to do is to make the last step of the job look at the result of the previous steps and then either raise an error to fail...

Third-party drivers used via Linked Servers are a notorious source of memory leaks. Depending on how your app maintains its connections, the use of the procedure sys.sp_xml_preparedocument to prepare an...

I have not used it however a SQL Skills blog came to mind...here is a good primer backed up with some real-world experience (see comments from readers too): http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2005-and-2008-Compression.aspx

6GB would be a fine place to start...max memory is an art not a science. Glenn has 6400MB recommended on a system with 8GB of RAM which is a shade...

No automation in your files is a good thing...you'll still need to install additional...

[Opinion] Simpler-to-read syntax:

DECLARE @StartDate DATETIME = '2011-11-17 03:17:14.000',

@StartTime DATETIME = '1899-12-30 04:34:47.993'

SELECT CAST(CAST(@StartDate AS DATE) AS DATETIME)...

I am pretty sure this has nothing to do witht eh fact that your using SSMS 2008 by the way, this has to do with how SQL Server looks for...

Double-post...direct replies here: http://www.sqlservercentral.com/Forums/Topic1081364-149-1.aspx

Best_boy26 (3/20/2011)

---

Do you know any easy way to get the data for this from exisiting table and exisitng data to post as a sample... ? I mean from SQL Studio...

It's best not to use SQL Server to access Excel. Microsoft does not stand behind any use cases where Excel is being accessed from unattended server-side code:

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

Ideally you should request...

If you don't know how to write C# code then why do you want to convert this code to C#?

If you are serious about using C# as your chosen .NET...

Koen Verbeeck (3/21/2011)

---

All the way down, there is a general...

Create a staging table on the same filegroup as your partition, use SWITCH to move the data from your table partition into the staging table. You can then TRUNCATE the...

Using the example Column data you gave what does the actual line of text look like in the file? 1|2||4|3 ?

Check out http://www.connectionstrings.com