Correct. But.

I prefer three separate triggers (Ugh!) for task such as this. To me, it's easier to maintain. And it's also easier to sort through the...

kwoznica (2/15/2014)

---

Hello all,

Is this thought the optimal way of logging such activity?

what is a more optimal way to perform logging?

Would a separate trigger need to be created for each...

Minnu (2/13/2014)

---

Hi Thank you for your response,the error was gone but the the output "name" is coming from "set @sql='declare '+@var +' nvarchar(max) set '+@var+' = ''name'' print '+@var "...

Scope.

@var1 is never being set within the scope of your code.

You need to read on sp_executesql and use that.

I had the same issue, transferring our database on an AWS instance to a local server. The database was significantly larger, 120GB.

We implemented transactional replication.

The basic steps I...

Grant Fritchey (1/22/2014)

---

SQLRNNR (1/22/2014)

---

No, schedule regular...

From what you describe in the original post, yes, the DBA's can probably do everything described without RDP access. You can view the event log, file sizes, etc. etc....

Do a search for Ola Hallengren. He has everything you need.

New golf clubs, and time to practice with them so that I can get my game close to where it once was.

But, as a DBA, I would have made sure that the data was clean before attempting an import!:-)

Jeff Moden (11/9/2013)

---

Gary Varga (11/8/2013)

---

Absolutely, but in the context...

You're still not very clear. And I couldn't resist the wise guy response...

Is the source of the data rows in a table? A string?, Something else?

CREATE FUNCTION dbo.ListPassengerNames()

RETURNS varchar(8000)

BEGIN

RETURN ('James, John, Bob, Kate, and Julie')

END

Go

This looks like an import problem!

Is the sample data you provided in a database table? If so, how did it get there?

It looks like the output into a...

Look at RDX also.