I'm thinking the problem is using " (double quotes) in building your string and probably not the correct number of ' (single quotes).

parag.sv (5/22/2015)

---

Hi, I guess everyone's suggesting be careful before using compression but no one's answering your question.

Yes, it will show the database size same as it was before you compressed...

Here are two ways to get the servername:

select srv.name as ServerName from sys.servers srv where srv.server_id = 0;

select SERVERPROPERTY('ServerName');

And what are you expecting to be returned?

Why the restriction?

Here is a snippet I found in a recently developed piece of code:

Stored proc parameter: @reportstring NVARCHAR(max)

DECLARE @tmpTbl TABLE ( value NVARCHAR(200) )

SELECT @tmp = ''

SELECT @i = 1

SELECT @length...

Has anyone tested the routines you will find here,http://www.sommarskog.se/arrays-in-sql.html,and see how they compare? Unfortunately my time is very limited but I found one the routines in a function here...

Greg Edwards-268690 (5/21/2015)

---

cunningham (5/21/2015)

---

Lynn Pettis (5/21/2015)

---

Welcome to The Thread! Now that you are here, you really should spend...

Welcome to The Thread! Now that you are here, you really should spend a few months reading the...

i1888 (5/20/2015)

---

I managed to made a backup locally rather than backup to another server, the backup looks good, I can restore to the client sql server, and also able to...

arulbabuvp (5/20/2015)

---

Hi All,

I initially created forum topic with the same name in the below link.

http://www.sqlservercentral.com/Forums/Topic1685563-3077-1.aspx

Thanks to Alan and Eirikur who has guided me post effective forum question.

I created a...

SQLRNNR (5/20/2015)

---

Ed Wagner (5/20/2015)

---

GilaMonster (5/20/2015)

---

Eirikur Eiriksson (5/20/2015)

---

This would be the one that wants to fix ugly queries with a sprinkle of hint perfume when all that's needed is a good...

arulbabuvp (5/20/2015)

---

Hi All,

I initially created forum topic with the same name in the below link.

http://www.sqlservercentral.com/Forums/Topic1685563-3077-1.aspx

Thanks to Alan and Eirikur who has guided me post effective forum question.

I created a...

Eric M Russell (5/20/2015)

---

meerack11 (5/20/2015)

---

Hello...

I am currently looking for job as sql developer company gives sql query to solve so can you help me where I can find...

Almighty (5/20/2015)

---

GilaMonster (5/20/2015)

---

Log_reuse_wait has nothing to do with the log not shrinking. It...