What sort of disk subsystem are you working with?

In general I've seen SANs used to handle the clustered disk resource, with both nodes of the cluster having access to the...

dawidjordaan (3/9/2010)

---

I will try this out and see what the auditors have to say and report back to this forum. I hope this is something I can slip by them...

Why not just use something like CDO or if your server is old enough CDONTS?

Basically brings Database Mail to SQL server 2000. Just for fun I was creating sp_send_dbmail stored...

I have to agree with the complainers here.

When one of the answers is none of the above, how do I know the abscence of a column name is accidental or...

Lynn Pettis (1/21/2010)

---

Have you checked model to see if that is how it is configured on each of the systems? You may not have fiddled with model, but someone...

david.wright-948385 (1/21/2010)

---

I bet this will turn out to be another "the intention of QOD is to make people think" or "you can't comment on this if you haven't submitted a...

2 MB mdf, 3 MB ldf here, and I know I haven't fiddled with...

Seeing as this is in the SQL 2k5 forum.

Personally if you have the time, I'd look at converting the GOTO's to TRY/CATCH blocks.

Just so much simpler to be able to...

Every time I read these articles about 4-4-5 my head hurts... and I vow again and again to make sure to not take a job with a company that follows...

Hmmm based on that I'd expect this to work though

declare @bob varchar(2000)

select

@bob = 'select * from sys.tables'

exec sp_executesql @bob

but instead I get

Msg 214, Level 16, State 2, Procedure sp_executesql,...

I'll bet its not... and here's why

Microsoft SQL Server 2005 introduces the max specifier. This specifier expands the storage capabilities of the varchar, nvarchar, and varbinary data types. varchar(max), nvarchar(max),...

That's odd because this query

declare @bob varchar(max)

select

@bob = 'select * from sys.tables'

exec sp_executesql @bob

Returns this message on SQL 2k5 when I run it.

Msg 214, Level 16, State 2, Procedure sp_executesql,...

I believe that indeed it was ANSI-89...

Jeff Moden (1/7/2010)

---

mtassin (1/7/2010)

---

jcdyntek (1/7/2010)

---

I will also check on the limits of character strings, however, if this is an internal string do you really need an nvarchar? if you...

jcdyntek (1/7/2010)

---

I will also check on the limits of character strings, however, if this is an internal string do you really need an nvarchar? if you used the varchar...