I don't think you've provided everything you need, anyway;

i don't see any relationship for the table [pstatus] table to your [patient] table.

your [patient] table should have separate fields for firstname/middle...

wow an awfully broad subject there;

take a look at the forum dedicated to Powershell and SQL server here

from there, you can see there are broad categories of uses, but one...

can you return a case statement instead?

SELECT

CASE WHEN @param1 = 1 THEN 1 ELSE THEN 3 END as column1,

CASE WHEN @param1 = 2 THEN 2 ELSE THEN...

details or ddl wasn't available, so here's my best guess.

is the trigger setting values on the table is is set for, or a completely different table ("Audit")?

because you...

grab a copy of sp_whoisactive here:

http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx

from there, you need to look at the parameters, but for example running this:

EXEC sp_whoisactive

@show_own_spid =1,

@show_sleeping_spids =1

will show me a...

you didn't mention if you followed HanShi's advice about pinging all the ip addresses you think you want to use for your cluster; it really does sound like somethign has...

ksatpute123 (6/17/2013)

---

I think it is far fetched because after searching the internet for days I found nothing.

I want to find out all the object referring the columns in a table....

by introducing a row_number function that partitions by the two columns, you cna find unique rows; fromt here, it's just the same query you had before, but hitting a subquery...

did you mean scripting existing files?

fastest way i think would be to right click on...

Almost everything in scripting is configurable as to whether a result is scripted or skipped;

spend some time reviewing the many scripting options that are in Tools>>Options;

As I remember, scripting of...

Great Sam! which SQL Saturday is this for? i know there is a local(for me) in the Fort Lauderdale area coming up in three weeks or so; I was wondering...

first thing i see is the non-Sargable WHERe statemnet in the first CTE:

cteMain is not Sargable:

WHERE (DATEDIFF(d, g.HireDate, GETDATE()) > 181

i think this is the equivilent, and would use...

hydbadrose (6/14/2013)

---

I have about 100 db's with mdf, ldf, and ndf files that I need to restore to the SQL 2008R2 on different instance. I have all the backups in...

I see the issue now.

bcp cannot take any input with carriage return line feeds.

your statement is easy to read, because it has the CrLf in it, but i'ts not valid...

probably permissions; when you go outside of a database, like to the command line, a user you do not expect(the startup account of the service) is used

does this code return...