Viewing 15 posts - 46 through 60 (of 87 total)
As Perry referenced, check that the cluster resources are coming online. I had this happen where the network name wouldn't come online because the login I was using didn't...
August 16, 2011 at 1:34 pm
Basically, you're using impersonation, the equivalent of clicking the check box if you were using the GUI to map the login. To use impersonation, the servers must be set...
August 10, 2011 at 2:35 pm
The audit file will store more than 1000 records, it's just that the log file viewer will only display 1000 records. I don't think there's any way to change...
August 4, 2011 at 9:29 am
Thanks for your input Leo. So, basically, you'd recommend Option 3, with log shipping rather than mirroring, and without the final step of renaming the instance? We'd really...
August 2, 2011 at 11:58 am
It's been my experience that the SQL Server service account is what would need access to the excel file. Not the user running the query.
July 28, 2011 at 12:34 pm
No. Since you definitely only want 10 rows, regardless of ties, I'd go with ROW_NUMBER.
July 27, 2011 at 8:25 am
So, working with GSquared's query as a basis, shouldn't this give you what you want?
;WITH CTE
AS (SELECT...
July 27, 2011 at 8:18 am
Why not just use GSquared's query with RANK instead of DENSE_RANK. That should give you just the 10 rows you want.
What do you mean by you're losing the sum...
July 27, 2011 at 7:03 am
Have a look at the RANK() function. Should make it very easy to get the top 10 per month.
Lots of examples and explanation:
http://weblogs.sqlteam.com/jeffs/archive/2007/03/28/60146.aspx
July 26, 2011 at 12:48 pm
You're correct in that you can't mirror a 2008 database to a 2005 instance.
My $.02, I'd go with option 2 (just seems cleaner to me), using your mirroring to minimize...
July 26, 2011 at 12:35 pm
You could probably do it with a DDL trigger. This link should get you started.
July 1, 2011 at 10:39 am
Really? I get the database associated with the spid. Tried it on multiple versions, even. Interesting.
To eliminate the extraneous:
DECLARE @FileName VARCHAR(MAX)
...
June 30, 2011 at 2:57 pm
The last column? (Not the column called DatabaseName, which for the original poster's purposes, can be omitted.) The last column is the dbid associated with the spid. ...
June 30, 2011 at 2:50 pm
Jonathan Kehayias has code that uses the default trace to get the SPID associated with a temp table. Join that with sysprocesses and you've got the database.
...
June 30, 2011 at 2:43 pm
From BOL:
Data at the Publisher and Subscriber can be non-convergent for a number of reasons:
* Data is updated at a Subscriber that should be...
June 28, 2011 at 9:39 am
Viewing 15 posts - 46 through 60 (of 87 total)