Viewing 15 posts - 526 through 540 (of 1,583 total)
Awesome, he'll be very happy on Monday 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 9, 2014 at 3:01 pm
Great points by SQLRNNR. Also check the local administrators group on the server running SQL Server. Any user who is added to the local admin group, will be...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 9, 2014 at 10:15 am
Sounds like homework 🙂
What have you been able to come up with so far? Can you please post your TSQL?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 9, 2014 at 9:52 am
1. Have any "new" records been inserted into the RestoreHistory table since they database was restored?
2. Try dropping and re-creating the trigger
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 9, 2014 at 9:41 am
You can't alias the "*"
You need a comma after the star, like so: DECLARE @Employee TABLE (FullName varchar(10), Salary money)
INSERT INTO @Employee
SELECT 'John Doe', 85000 UNION ALL
SELECT 'Jane...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 9, 2014 at 9:04 am
I believe you actually need to install the Report Builder functionality
Try this: http://technet.microsoft.com/en-us/library/dd207038.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 8, 2014 at 9:43 am
You can use this snippet of code I found online (I believe it came from mssqltips.com), this will give you the proper files to load since your last full backupDECLARE...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 8, 2014 at 8:59 am
You could more easily do this via SSIS (whereby you could set the "destination" of the SQL Task to a file destination, setting all kinds of options), however in TSQL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 8, 2014 at 8:41 am
Yep, or you can add it to the base amount like so:
SELECT 58261.21, ROUND((58261.21 * .1), 2), ROUND((58261.21 * 1.1), 2)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2014 at 4:14 pm
Is the service account a member of the local admin group on the server its running on?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2014 at 1:11 pm
Hey everyone! It's ugly code Friday!!! :hehe:
Here's the ugliest way around the issue (as pointed out by SQLRNNR)D-ECLARE @String varchar(250)
SET @String = 'xxxdb_backup_2014_02_06_073328_1849272.trn'
SELECT LEFT(@String, CHARINDEX('_', @string, 7)) + REVERSE(SUBSTRING(REVERSE(@String), 5,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2014 at 9:45 am
Please post your execution plan (you can obtain this by pressing "Ctrl-M" before running your query. Also, obtain the STATISTICS IO and TIME for the query (for each one)...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2014 at 8:06 am
Yes if/when you need to reinitialize the publication you will lose all the data in the STAGING server....not much you can do there. The only suggestion I could offer...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2014 at 8:03 am
You can also use this script (there are many at this site by the way)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2014 at 7:58 am
Just so you know, it's kind of dangerous to be using queries like this if you're not sure what they actually do (just saying). This being said, the SUBSTRING()...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 7, 2014 at 6:10 am
Viewing 15 posts - 526 through 540 (of 1,583 total)