Looking For Some Magic

May 16, 2006

... well, perhaps some sophistication. The setup:

Server A publishes to server B via transactional replication. Server A is to be shut down while some electrical work is done. So we fail over to server B for a couple days. My underpowered brain says to shut down replication, possibly fail over well in advance of the power outage.

Then, when the electrical work is done and server A is restarted: 1) stop work on server B, 2) ?copy? the database on B to A (I suppose after deleting it from A), and 3) redoing the replication from scratch.

Can anyone recommend a better process?

I am very gratefull for any enlightenment.

View 1 Replies


ADVERTISEMENT

What Is Magic Table?

Jan 1, 2004

Hi,
I want to know about magic table in SQL Server. What is actually magic table?
I tried to find information through google but I didnt able to get sufficient information about it. Can any budy help me in this regard?

Thanx.

View 3 Replies View Related

What Are Magic Tables?

Feb 23, 2004

Can any one tell me what are magic tables in sql server?

View 6 Replies View Related

Publishing Wizard - Bad Magic?

Aug 26, 2007

I've been working with the Database Publishing Wizard and have found what I initially thought was a bug but have decided is a rather nasty "feature".  Or am I missing something?
I have membership implemented in a live database. I took a backup and loaded it into a local database. I created a new table locally that is foreign-keyed off aspnet_roles, and added some data.
Using the Publishing Wizard for a partial deployment, I followed the steps which seem perfectly clear to script out ONLY the new table and its data. The screens provide a nice GUI for selecting specific database objects, and I carefully chose the one new table.
From good habits I looked at the script before deploying it. It drops and recreates aspnet_roles and aspnet_applications as well (and inserts the data from the development tables).
Presumably this is because of the foreign key relationships. But there's no need to do so. What if I or another developer had added in some roles to the live table in the meantime? This script would blow them away.
Am I missing an option with the Wizard that would script out only what is specified? I've tidied up the script (i.e. removed the undesirable sections) - but this seems to be a naughty wizard. Any thoughts?

View 5 Replies View Related

What's Magic About DT_STR And Size 50

May 15, 2006

Okay, this is probably my own stupidity but here goes. I am trying to make a very rudimentary package. I've got a data flow that has a flat file source. This source has fields delimited by the | symbol. I give the fields in the flat file source names. The first field is always exactly 1 character. When I use the advanced editor to look at the fields' properties, I see the first field, called ProductLine, is considered to be of SSIS internal data type DT_STR with a length of 50. I change the 50 to 1 because that is as long as that field is.

No matter what I do, when I close the advanced editor and then open it again, the field length for ProductLine is again set to 50. The field is 1 long, not 50 long. How can I make the setting of 1 be retained? Nothing I do changes it. What is the point of allowing the length to be editable if the edit is not retained?

Thanks in advance,



SW

View 4 Replies View Related

What Are The Magic Tables In Sql Server ?

Mar 11, 2008



Hello what does it mean ? Is it really posible in SQL Server ? If yes then How ?

View 7 Replies View Related

Magic Tables With Text Columns

Oct 6, 2004

Hi folks,

I need to execute some kind of

select a,b,c into #inserted from inserted

a = int
b = varchar(50)
c = text

Easy so far. But I what I need is to find out whether the audited table contains text(or nText / image) columns or not. If it contains any text columns the statement should automatically be changed to

select a,b into #inserted from inserted

Remember that the trigger must be usable for any table in the database without manually entering the tables structure or the column names.

Best would be fetching the structure fropm the system views (INFORMATIONSCHEMES)

Any suggestions ?

Thanks a lot!

Stefan

View 1 Replies View Related

Trigger :: Xp_smtp_sendmail :: Parameter Value In Message/subject :: Magic Table

Oct 23, 2007

OK so now I'm setting up a trigger to email info to different people based on values INSERTed into one of my tables. I'm using an IF statement to determine who I'm giong to send the mail to, but I don't really understand how to include the data (parameters) in my message. Thanks for any help. Here's what I have so far.





Code Block
ALTER TRIGGER [smallin].[trig_test]
ON [smallin].[DATALIST]
AFTER INSERT
AS
declare @rc int,
@post bit,
@pre bit
SELECT @post = [POST], @pre = [PRE] FROM inserted
IF @post = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is post data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'

ELSE IF @pre = 1
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'ln.li@mydomain.com',
@FROM_NAME = N'Alert Mailer',
@TO = N's.mallin@mydomain.com',
@replyto = N'ln.li@mydomain.com',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'This is pre data',
@message = N'Goodbye MAPI and Outlook',
@messagefile = N'',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'exchange.mydomain.com'





View 5 Replies View Related

Unzipping A Zip File-The Magic Number In GZip Header Is Not Correct.Make Sure You Are Passing In A GZip Stream.

Jan 25, 2007

I have the following code in an SSIS package and I get the following error:

Error: 0x0 at Unzip downloaded file, Boolean ReadGzipHeader(): Unable to decompress C:ETLPOSDataIngramWeeklyINVEN.zip; The magic number in GZip header is not correct. Make sure you are passing in a GZip stream.

Error: 0x4 at Unzip downloaded file: The Script returned a failure result.

Task failed: Unzip downloaded file

The zip file unzips perfectly using winzip utility, so that file is definitely not a problem here.

The code I am using in a script task is as follows:

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is the entry point of the Script Task.

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Imports System.Text

Imports System.IO.Compression

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

'

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

'

' Add your code here

'

Dts.TaskResult = Dts.Results.Success

Dim success As Boolean = True

Dim workFilePath As String

workFilePath = Dts.Variables("zipFilePath").Value.ToString()

If File.Exists(workFilePath) Then

If Not workFilePath.EndsWith(".zip") Then

Dts.Events.FireInformation(0, "", workFilePath + " is not compressed; skipping decompression", Nothing, -1, True)

Return

End If

Dim uncompressedFileName As String

Dim bytes(Int16.MaxValue) As Byte

Dim n As Integer = 1

Try

uncompressedFileName = Dts.Variables("unCompressedFileName").Value.ToString()

Dts.Events.FireInformation(0, "", "decompressing " + workFilePath + " to " + uncompressedFileName, Nothing, -1, True)

Using writer As New FileStream(uncompressedFileName, FileMode.Create)

Using compressedStream As Stream = File.Open(workFilePath, FileMode.Open, FileAccess.Read, FileShare.None)

Using unzipper As New GZipStream(compressedStream, CompressionMode.Decompress)

Do Until n = 0

n = unzipper.Read(bytes, 0, bytes.Length)

writer.Write(bytes, 0, n)

Loop

unzipper.Close()

End Using

compressedStream.Close()

End Using

writer.Close()

End Using

Catch ex As Exception

Dts.Events.FireError(0, ex.TargetSite().ToString(), "Unable to decompress " + workFilePath + "; " + ex.Message, Nothing, -1)

success = False

Finally

If success = False And File.Exists(uncompressedFileName) Then

Dts.TaskResult = Dts.Results.Failure

File.Delete(uncompressedFileName)

End If

End Try

Else

Dts.Events.FireError(0, "", workFilePath + " does not exist", Nothing, -1)

Dts.TaskResult = Dts.Results.Failure

Return

End If

End Sub

End Class

Instead of the GZipStream do I have to use some other stream class for a zip file.  Please let me know.

Thanks,

Monisha

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved