Viewing 15 posts - 91 through 105 (of 172 total)
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
April 12, 2005 at 7:08 am
I finally got it figured out. There was some malformed data hidden deep inside the data file.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
April 7, 2005 at 2:03 pm
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. ...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
March 3, 2005 at 7:49 am
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
March 1, 2005 at 1:09 pm
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
March 1, 2005 at 6:51 am
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
February 1, 2005 at 10:02 am
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 #filelist(
logicalname nvarchar(128),
physicalname nvarchar(260),
type char(1),
filegroupname nvarchar(128),
size numeric(20,0),
maxsize numeric(20,0))
SET @sql...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
December 15, 2004 at 7:44 am
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
December 9, 2004 at 12:22 pm
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
December 9, 2004 at 10:00 am
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),...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 28, 2004 at 8:27 am
Thank you for the clarification.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 15, 2004 at 9:31 am
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
October 5, 2004 at 1:00 pm
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
September 1, 2004 at 8:21 am
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
September 1, 2004 at 8:07 am
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...
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 18, 2004 at 12:25 pm
Viewing 15 posts - 91 through 105 (of 172 total)