ssurekha2000 (5/16/2012)

---

iam using if in SP

if (@lused = '')

...

This way you will be able to script only one...

lanky_doodle (5/14/2012)

---

Thanks all.

Divine Flame, yours seems the best to follow, but I get this;

Msg 537, Level 16, State 3, Line 9

Invalid length parameter passed to the LEFT or SUBSTRING function.

Not...

lanky_doodle (5/14/2012)

---

Hiya,

Is there a way to handle multiple different values, but treat them as the same.

I.e;

NO | NAME

-----------------------

1 | Samsung...

ßhavin (5/12/2012)

---

My DB is on 2005, now i wanna move it to new server that is Sql Server 2008.

I have imported Tables & views from old to new server....

Simha24 (5/11/2012)

---

I returned following code...but it is not working fine

DECLARE @fileName VARCHAR(50)

DECLARE @name sysname

DECLARE @sqlcmd VARCHAR(1000)

SET @fileName = 'D:\data'

DECLARE table_Cursor CURSOR FOR

SELECT name FROM sys.objects where type='U';

OPEN table_Cursor;

FETCH NEXT FROM...

justoti (12/29/2011)

---

Hi experts,

I am testing the connection between 2 SQL server express 2008 instances: one on win7 32bit the other win7 64bit. Windows authentication, same domain. The user is th...

Thanks for sharing, so Matt was spot on :cool:.

TimParker (5/10/2012)

---

I am still sitting here scratching my head on this one. Something that I don't think is the issue, I can store my Full backups and Differentials in the...

HowardW (5/10/2012)

---

Divine Flame (5/10/2012)

---

HowardW (5/10/2012)

---

Depends on the reason for it. If the reason for preventing DML is to avoid long locks when another process is running, an after trigger doesn't...

TimParker (5/10/2012)

---

I just tried to run it manually, hadn't done that yet....and got the same error.

As far as I can tell, it is a complete good backup, according to...

HowardW (5/10/2012)

---

Depends on the reason for it. If the reason for preventing DML is to avoid long locks when another process is running, an after trigger doesn't help at all.

FYI,...

TimParker (5/10/2012)

---

I just ran the query and on this particular server there are 3 Databases. Two of which are not even currently being used (they are older versions of the...

TimParker (5/10/2012)

---

I hope I am posting this in the correct place. I have been doing a lot of reading until now. 🙂

I just started a new job last week. I...

Kwisatz78 (5/10/2012)

---

Hi all - Until we get to SQL 2012 it looks like i am going to have to set up a mirroring configuration for 2 of our SQL servers....