You said you don't INIT the transaction log backups so I'd suspect that that is what's continuing to grow.

Or, maybe the problems outside of SQL and files are being copied...

Could you help me regarding this one.. I have a table where i sourced my macaddress in the following format (00:02:A5:E7E:40). do you have any means of converting this into...

Hi Mark,

Thanks for the feedback! I should have pointed out this was for Windows authenticated logins, not SQL logins, which follow a different format.

I got the idea for this...

For a onetime import you could use the Import and Export Wizard in SSMS; Right click on your database, select Tasks/Import Data. Excel will be one of the options.

If...

Marios,

Some explorer once set off to prove the world was round. Zillions of people said they were crazy, that the world obviously was flat. No matter what the...

Since you have @smtpserver defined as a VARCHAR(25) I would look at the length of what's being passed in for that.

Edit: The reason for that error may be that...

You could turn the list into a table and use aggregate functions.

This article has details on how to do that: Arrays and Lists in SQL Server

In your example, what values did you use from table A and table C to generate table B?

You may want to look at OfficeWriter for working with Word documents in Reporting Services.

Officewriter - Reporting Services

Designing and Delivering Rich Office Reports with SQL Server Reporting Services 2005 and...

How to automate Word to perform a mail merge from Visual Basic .NET

You probably could do this in SSIS with the Script Task but that just doesn't seem like...

Jeff Moden (3/29/2008)

WHY??? A proxy account for xp_CmdShell will be much more secure than...

I haven't tried this in the CLR stored procedure but the System.Diagnostic.Process class might be of use.

Example:

Dim strCommand as string = "NET USE R: \\Server\Share"

System.Diagnostics.Process.Start("CMD.EXE",strCommand)

Here are two ways you can work with the rollover files.

Open SQL Profiler and select File/Open/Trace File, select the first file in the rollover set. Once that loads you'll be...

Following Lynn's lead, here's from a server that does not work.

Microsoft SQL Server Management Studio 9.00.3042.00

Microsoft Analysis Services Client Tools 2005.090.3042.00

Microsoft...

Jack,

This might be a .NET Framework 2.0 service pack 1 issue.

Based on three servers, the only one that appeared to work was the one without SP1. Here's the version...