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.

bryan van ritter (9/17/2013)

---

Hi,

i am trying to convert a nvarchar column to a decimal value.

the nvarchar column has empty records as well as NULL values.

now when i try...

Microsoft's move in this area does not surprise me.

Simply put, they were not making money on this program. They probably are making lots of money on the...