Thank you...I will dig into this thread right now...

arslan_ch (5/27/2010)

---

If you have SPSS software licence then you can save the data in difference formats like csv, excel etc.

If you just have SAV file then you will need API...

Julio J. Bueyes (5/25/2010)

---

Hi, I think that the sav file extension used by SSPS is a data file, the data are stored into a particular format, as you can see...

this article gave me an idea about the problem I'm working on....Most of all, I like the way the article is presented.

GilaMonster (3/10/2010)

---

No it won't.

Count(*) scans the smallest index on the table...

Chris Morris-439714 (3/10/2010)

---

Like Lutz, I don't have an answer to why you can't use COUNT().

However, I'd suggest that, since you can't (and shouldn't be able to) use MAX() by...

lmu92 (3/9/2010)

---

I don't have an answer why you cannot use a COUNT function on a uniqueidentifier data type.

But considering it's the primary key I'd say COUNT(*) would work as a...

Updating the contents of a file is a research question. Moreover, it depends on your requirements to update it through sql server or do it directly.

The part I have questions...

It looks to me that the files reside in a windows folder like any other file which you can indeed rename or delete but when you try to run a...

We have a tool that will scan through...

Test it and find out, in a dev database. That's what I'd do. If it actually matters which it will do, is there a reason to not use begin...commit?...

beautiful. Thanks, Brad.

I had the same code in my mind but was unclear if I can use them. Cascade delete is not an option for me. As we dont have...

Great example, RJ. Of course, A specific answer will be dependent on the specifics details of your requirements. For instance is "msdb.dbo.sp_send_dbmail" really a business requirement or is it just...

RBarryYoung,

I would like to see how you can eliminate using a CURSOR or WHILE loop for sending emails using "msdb.dbo.sp_send_dbmail". My requirement would be to send email notifications to managers...

Thanks, Steve.

We actually disabled the default trusted connection for testing purpose thinking we had the sa password. but unfortunately we didn't hence we had this problem. we disabled the trusted...