Viewing 15 posts - 46 through 60 (of 82 total)
Yes, the function on it's own works fine, when the ID is passed as a parameter.
November 2, 2018 at 8:49 am
Scott.
Spot on. That was the issue. The missing table has a different schema_id other than the default "1" for dbo.
My script is not filtering on "schema_id".
November 2, 2018 at 6:27 am
Hi Lowell,
Sorry for late reply on this. I ran your scripts and got this output. Probably the same as your output. What else could I do to make...
May 9, 2017 at 8:07 am
Lowell,
There is only one Exec.
Declare @command varchar (max)
SELECT @command = s.Colzs
FROM(SELECT
Colzs = STUFF((SELECT...
April 26, 2017 at 7:41 am
Hi Lowell,
After the change, I am getting the same error. I removed Set command before Declare too.
Vin
April 26, 2017 at 7:10 am
Thank you Adi.
I can't change the column type. So this solution is fine for me. Insrtead of varchar(max) I only need max 25 characters.
Vinay
March 16, 2017 at 7:50 am
February 13, 2017 at 10:42 am
This topic is in the wrong section. I forgot to mention the database is on SQL 2008 R2.
I have asked webmaster to move the topic.
Thank you,
February 13, 2017 at 5:56 am
Eirikur Eiriksson - Monday, February 13, 2017 5:17 AMMy guess is that the application / package renames the actual backup to DoNotDeleteThisFile.txt
Eirikur,
If...
February 13, 2017 at 5:42 am
I can't reconcile your two statements "It all works fine magically" and "the process...
February 13, 2017 at 5:37 am
Thank you, Eirikur.
I had a look at Ola's scripts and it does not cover "other" elements of SQL databases to backup.
User and System Databases are being backup daily,...
November 10, 2016 at 5:47 am
Go To Flat File Connection Manager and then Advanced.
Increase the column size there. And then do Save All.
Also ensure you have a Text Qualifier. Generally doubleQuotes.
it's possible...
November 8, 2016 at 9:31 am
Hi Adi,
The clause Option(recompile) works well.
Execution time 59 seconds;
and 54 seconds for constant values supplied.
Before Option(recompile), it was "2min 31 sec."
I will also use Stored Procedure. That's a...
November 8, 2016 at 9:20 am
Hello John,
Here is the table structure:
CREATE TABLE [dbo].[tableA](
[Id] [int] IDENTITY(1,1) NOT NULL,
[EmailAddress] [varchar](60) NULL,
[event_Type] [varchar](25) NOT NULL,
[MessageName] [varchar](255) NULL,
[DeliveryDate] [datetime] NULL,
[event_Date] [datetime] NULL,
[BroadcastId] [varchar](25) NULL,
[subjectline] [varchar](100) NULL,
[firstname] [varchar](50) NULL,
[surname]...
November 8, 2016 at 8:58 am
Gail,
I can't tell if the XACT_ABORT is On or Off.
But the way to replicate auto rollback is this way:
select * into #temptable
from basetable
select * from #temptable
begin tran
...
September 22, 2016 at 5:33 am
Viewing 15 posts - 46 through 60 (of 82 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy