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...

Ed Wagner (6/14/2013)

---

I've always done this using a .NET application and found it far easier than trying to force it with T-SQL. The first big hurdle in doing it...

this post has...

here's my best guess, based on your original query, using row_number() like kingston suggested:

SELECT

ROW_NUMBER() OVER (PARTITION BY mem.MemberID ORDER BY t.TransactionDate) AS RW,

mem.MemberID,

mem.FirstName + ' '...

usually this is done in a programming language, as there's a lot more tools and control there.

Doing it in TSQL only, the file has to exist, and you have to...

Ed you are correct, i'm still not getting what i'm after;

if i add these five more rows to my sample data above, i would expect five values with [1] and...