Viewing 15 posts - 736 through 750 (of 1,583 total)
Sounds suspiciously like homework...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2013 at 6:13 pm
The software needs to be registered using your proxy account that is used for the SQL Agent. You know how when you install some new software on the box,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2013 at 6:12 pm
A silly question I'm sure but is your desktop a member of the same domain? Or are you getting an error? i.e. (Cannot generate SSPI context?)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2013 at 6:05 pm
Thanks Lynn, got what I needed from there (not sure why my first couple Google searches didn't find that) - appreciate your help!
Users who have the SHOWPLAN, the ALTER TRACE,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2013 at 2:01 pm
Christian Buettner-167247 (2/21/2013)
Table Hints (Transact-SQL) - SQL Server 2008 R2
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2013 at 9:51 am
Scratch that, I guess there's no real way to tie the statement back to a user :crazy:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2013 at 10:53 am
I believe that's correct. But depending on how long ago it happened the statements used might still be in the sys.dm_exec_query_stats DMV?
EDIT: I meant the sys.dm_exec_sql_text DMV
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2013 at 10:49 am
I don't believe this is possible unless you already have Change Data Capture running
There is nice app from ApexSQL which can be used as a trial and literally and visually...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2013 at 10:42 am
Pretty easy to change, however I'm not 100% certain you'll need to restart the MSSQL service in order for it to take effect (check BOL)
Right-Click on your SQL Server instance,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 19, 2013 at 9:02 am
m.rajesh.uk (2/16/2013)
my doubt is how to send the backup file to vendor through FTP
It is no different than sending any other file. If you aren't comfortable with the command-line...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 16, 2013 at 11:04 am
You can set up alerts under the SQL Server agent, I believe the type is "SQL Server Performance Condition Alert" and it will allow you to set thresholds for each...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 16, 2013 at 11:01 am
From my point of view walking into a new company as a "new" DBA is a intimidating task. As you can tell from the answers (good ones) provided here,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 15, 2013 at 10:44 am
Yes you can FTP the backup (I believe you'll need to use the "bin" flag), or burn it to a DVD or other storage media and send it via courier?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 15, 2013 at 10:30 am
Bill (fluffydeadangel) (2/14/2013)
Sadly I think our "custom trace" omits these results. I'll have to add it back for future use.
The default SQL Server trace runs in the background and is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 14, 2013 at 1:14 pm
This is inaccurate (at least for 2005/2008). SQL Server's default trace file records this information. As a test, run something similar to USE [MyDB]
GO
DBCC SHRINKFILE (N'MyDB_log' , 2048)
GO
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 14, 2013 at 10:55 am
Viewing 15 posts - 736 through 750 (of 1,583 total)