I can tell you it took some playing when I was doing it. Problem is it was so long ago it is hard to remember what we did. ...

Brandie Tarvin (8/8/2012)

---

Just really confused. You should have...

I'm thinking about trying to get to the SQL Saturday in SLC in October. Hoping I will be able to swing it, but will probably need to find a...

tim.cloud (8/8/2012)

---

I use the following stored proc to find and record my index fragmentation in SQL 2005 & 2008:

ALTER PROCEDURE [dbo].[usp_Index_Fragment_Daily_Log]

-- Add the parameters for the stored procedure here

AS

BEGIN

-- SET...

Please read the following, it discusses Indexed Views:

http://msdn.microsoft.com/en-us/library/ms191432(v=sql.100).aspx

Can you you get the BCP to work manually? I know I have done this myself, just can't remember how I handled it of the top of my head.

dwain.c (8/8/2012)

---

You can try something like this, although I don't get the same counts as you do:

;WITH Unpivoted AS (

SELECT RaceCode, Code, Value

...

MyDoggieJessie (8/7/2012)

---

Not certain why you'd want to do this type of thing in SQL instead of Reporting Services or Excel (but I'm sure there's reasons ;-)) - here's a great...

Go to sqlpass.org and do a search for user groups in your area. You could make some good contacts there.

OMG.

OP: I run this T-SQL to change the location of these datbases but when I try to open the database SQL says it can't find the files.

Me: Have you physically...

Angelindiego (8/7/2012)

---

Lynn....no, I haven't manually moved the files. I was hoping to be able to do it by script, as it has to be done on several servers. ...

Heimillers (8/7/2012)

---

I've seen a lot on LSASS.EXE CPU and Memory Bloating. Since I'm having the problem in the context of SQL Server, I'm posting in this forum....but the hotfix solution...

If you undo what you did, in other words run the t-sql to put them back to their original location, does the database open successfully?

Dumb question, have you physically copied the mdf/ldf files to the new location after running the t-sql code and taking the database offline?

Python