Viewing 15 posts - 1,006 through 1,020 (of 1,137 total)
cgr (7/7/2009)
How do you create a Windows authorized SQL server login that only has permission to execute the stored procedures of a particular database?
If you want it to have execute...
September 3, 2009 at 2:59 am
bad practise to use sp_ prefix, microsoft recommends against it. Most people I know use usp_ but it is a personal thing.
September 3, 2009 at 2:44 am
Michael Valentine Jones (9/2/2009)
A...
September 3, 2009 at 2:29 am
If this is not yet fixed, let us know and give us more information so we can help
September 3, 2009 at 2:25 am
DBAsql (9/2/2009)
Hi,I need to change the target location of a backup job scheduled previously from maintenance plan.
Please let me know how this can be done?
Thanks,
Keerthi
go into the maintenance plan and...
September 3, 2009 at 2:23 am
Chirag (9/3/2009)
If you are not going to take advantages of SQL 2005 specific features why upgrade ?
simple, mainstream support for sql 2000 has expired, so unless you pay for extended...
September 3, 2009 at 2:17 am
Like it has been mentioned you can always take the biggest tables and put them in a separate filegroup. finding out the data pages allocation by table by file, seems...
September 3, 2009 at 2:15 am
Sounds like your boss has read a magazine which recommends it, maybe you should ask where he got his information from, so you can disapprove it, based on his source.
September 3, 2009 at 2:11 am
September 3, 2009 at 1:57 am
DKG (9/3/2009)
I don’t know where you are getting confuse, anyway let me explain again. I have a scheduled database backup job everyday at 22:30 it works...
September 3, 2009 at 1:56 am
Check to see if you have any scheduled jobs running at the time as well.
September 3, 2009 at 1:52 am
damn it John 😛 i was just about to reply. lol
Totally agree with what John has said. if you new to sql. SQL will choose the best index's to use....
September 2, 2009 at 9:32 am
Tommy Bollhofer (9/1/2009)
You could put the output of msdb.dbo.sysjobactivity into an SSRS report and create a subscription to deliver the report via e-mail.
Well that might work, if you want the...
September 2, 2009 at 9:26 am
yep sounds good. let us know what you end up doing 😀
September 2, 2009 at 9:17 am
I cannot find it lol.
been looking through the system tables/views. need someone with more knowledge of sql internals. It should be possible to tie it down using the data pages....
September 2, 2009 at 9:02 am
Viewing 15 posts - 1,006 through 1,020 (of 1,137 total)