Forum Replies Created
Viewing 15 posts - 61 through 75 (of 1,183 total)
-
RE: SSMS Scripting disable trigger?
Search BOL for DISABLE TRIGGER... 🙂
and to check if enabled or disabled see ...
SELECT * FROM sys.triggers______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Percent of number in top row
You're looking for the FIRST_VALUE function.
DECLARE @testData TABLE
([Industry] VARCHAR(2)
,[Naicstitle] VARCHAR(50)
,[NumMatch] INT)
INSERT @testData (Industry,Naicstitle,NumMatch)
VALUES
('00', '', 1025)
,('62', '',...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SSRS report with custom filename and tab name for email delivery subscription
I've not tested against 2012, you'll have to try and post back here if it does work.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SSRS report with custom filename and tab name for email delivery subscription
This will get you the results you want. Maybe a bit overkill with the custom subscription part, but it's the only way I've found to do it.
http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69546/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Deadlock - One node is in the Resource database?
Ok, there were multiple deadlocks over the weekend. Nearly all are fairly much the same as the log text below.
There is definitely something wrong with replication. Any thoughts, this isn't...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: use 2 datasets on detail line of SSRS 2008 r2
Mark Fitzgerald-331224 (10/10/2013)
Jason Selburg (10/10/2013)
Personally, I'd move the decision logic to the procedure. have it accept both parameters as nullable, then handle your logic there.The Report then only needs one...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: use 2 datasets on detail line of SSRS 2008 r2
Personally, I'd move the decision logic to the procedure. have it accept both parameters as nullable, then handle your logic there.
The Report then only needs one dataset.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Deadlock - One node is in the Resource database?
Thanks Gail, it may be tomorrow or later before 1. I get the permissions and 2. the deadlock happens again.
I'll let you know as soon as I have more...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Deadlock - One node is in the Resource database?
try this link ...
http://i129.photobucket.com/albums/p207/jselburg1970/deadlock.png
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Deadlock - One node is in the Resource database?
GilaMonster (10/10/2013)
Err.. where?Ok, what are you asking? Where what? 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Deadlock - One node is in the Resource database?
I'll need to get permission from the client to turn on the trace, but in the meantime here is the limited information from the SQL Error Log.
** Each of these...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Error in restoring database
The server where the backup was created is 10.50.2500.0 or SQL Server 2008 R2 SP1, the version you are trying to restore to is 10.00.2531 or SQL Server 2008 SP1.
You'll...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SELECT * INTO Table without propagating IDENTITY attribute?
deleted
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: SELECT * INTO Table without propagating IDENTITY attribute?
Why not drop the column after creation and before putting anything in it?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
RE: Central management Server
My understanding is the CMS allows for the logical grouping of your registered servers that can be shared in your organization.
It also allows you to run queries against all servers...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg
Viewing 15 posts - 61 through 75 (of 1,183 total)