Duh, 20 lashes with a wet noodle on me!

I had it set to row 3 earlier.  Apparently at some time I changed it to row 2 and then I never...

I finally got it figured out.  There was some malformed data hidden deep inside the data file.

Thanks Brian.  I don't know why the images failed, they were in the post preview.

Anyway, I wasn't aware of that procedure.  I ran it and it verified what I expected. ...

I would strongly urge you to consider using one of the methods mentioned here because Windows authentication is much stronger and more secure than SQL authentication.  Also, using SQL authentication leaves your login...

The problem is that the project is not using your login but the .NET (ASPNET) login to try to connect to the SQL Server.  I see your computer name is...

Go to the following web site for another option for mail:

http://www.sqldev.net/xp/xpsmtp.htm

We don't use Exchange here so we had to find another solution to SQLMail.  We have been using this...

Assuming you only have one data file and one log file, try the following:

CREATE PROC RestoreDBs(

 @db_name varchar(128),

 @backup_device varchar(500),

 @new_device varchar(500))

AS

DECLARE @sql   varchar(100),

 @data_logical_filename varchar(500),

 @log_logical_filename varchar(500),

 @new_data_device varchar(500),

 @new_log_device  varchar(500)

SET @new_data_device = @new_device + '.mdf'

SET @new_log_device = @new_device + '.ldf'

CREATE TABLE...

When reading your post, I realized I didn't mention that I was trying to do this without looping.  I was looking for a one query solution.  (See my solution above.)

I knew...

Thanks but I finally got it figured out right about the time you sent this e-mail.

Here is my solution:

INSERT INTO mytable(id, mydate)

SELECT a.id, DATEADD(dd, -1, a.mydate)

FROM mytable a JOIN mytable...

Just a note.  We also have the problems with printing from the HTML output so unless it is absolutely necessary to output a report in HTML (with the report viewer),...

Thank you for the clarification.

I have found the problem.  It had to do with account delegation.  I am working through all of my account setup to make them work properly.  I have gotten some...

I'm assuming you are talking about SQL Reporting Services.  If so, you will have to build your report table to have the maximum number of columns you will want on...

Here's an example of a script I built that runs every night to script all of our custom stored procedures.  It creates multiple script files, one per stored procedure and...

Steve,

In your example from your Batching article, I have a question about the following example:

Declare @t int, @i int

Set @i = 5000

Set rowcount 1

While @I > 0

Begin

   Select @t...