Viewing 15 posts - 676 through 690 (of 1,583 total)
DECLARE @ID int
SET @ID = 3
SELECT ID + 1 WHERE ID = @ID
?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 9:12 am
Place trigger on the msdb..sysjobs table for each server you wish to monitor - something like the code attached will work, just add in the statements to check the INSERTED...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 8:44 am
What's the network connection/switches between all this hardware? Is the DB server connected to the SAN via a fiber-channel or regular ethernet? Also does the same performance issues...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 8:33 am
Not meaning to hijack the thread (but I have a question that is directly-related). If dealing with 2 logs files (the primary LDF file and an additional) and log...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 8:08 am
Also, the date datatype won't work in SQL 2005, it's new to SQL 2008
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 7:45 am
Something simple?
DECLARE @Tmp TABLE (col1 varchar(8))
INSERT INTO @Tmp
SELECT '201210' UNION ALL
SELECT '201211' UNION ALL
SELECT '201212' UNION ALL
SELECT '201301' UNION ALL
SELECT '201202'
SELECT CONVERT(date, col1 + '01', 101) FROM @Tmp
(Date)
2012-10-01
2012-11-01
2012-12-01
2013-01-01
2012-02-01
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 9, 2013 at 7:44 am
If you haven't specified it during the initial install, it's set to 0 by default, meaning that it happens automatically (running approximately every 1 minutes for active DB's)
Reference MSDN here
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 28, 2013 at 1:23 pm
How can I remove my post?
😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2013 at 4:22 pm
The issue is it can't read the file at D:\unc\DAMIAN-PC$PCTWO_TESTOWA_TEST
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2013 at 4:21 pm
This error is "The system cannot find the path specified"
Check that the service account (running your replication agents, etc.) have the necessary permissions to the directory(ies) - currently it can't...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 18, 2013 at 12:12 pm
At the SQL Server instance level do you have the publisher and subscriber to "Allow Remote Connections?"
And in your linked server, have you enabled "data access"?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2013 at 5:14 pm
I'm going to assume there's more rows in the table than 2, and you want just the last 2 of them ordered in ascending order?
Try:
;WITH MyData AS (
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 16, 2013 at 6:59 pm
There are many alerts you can set up via the replication monitor (I encourage you to set those up as well). To create a custom process to track (this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 16, 2013 at 10:49 am
GilaMonster (3/15/2013)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 16, 2013 at 10:07 am
I'd recommend you place your TEMPDB Log file on a different drive...
Seems like nice hardware for the server regarding CPU's but what about RAM and the disk subsystem? I...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 15, 2013 at 1:03 pm
Viewing 15 posts - 676 through 690 (of 1,583 total)