Viewing 15 posts - 76 through 90 (of 104 total)
Carl Federl (5/24/2008)
There is also an extended stored procedure that can be used but the resource usage is substantionally higher than a distributed SQL to AD.exec master.dbo.xp_logininfo 'BUILTIN\Administrators','members'
Nice one Carl.
May 25, 2008 at 11:29 pm
Hi there,
- Run 'compmgmt.msc'.
- Expand System Tools & then local users & groups.
- Select the groups folder.
- Check the properties of the Administrators group.
Regards,
Lian
May 24, 2008 at 1:53 am
You can this:
declare @input varchar(100),
@id int,
@helpText varchar(max)
set @input = 'Your Stored Proc Name'
set @id =(select top 1 object_id
from sys.objects
where [name] = @input
and type_desc =...
May 15, 2008 at 2:02 am
Thanks Gail. Just double-checked on my side as well... 56GB :blink:
May 15, 2008 at 12:50 am
- In Management Studio, right click on the database.
- Select tasks -> Backup...
- There's a button called 'Script' at the top of the next screen that will create a...
May 15, 2008 at 12:22 am
Never really thought about it that way.
I occasionally play guitar & enjoy the break from using technology i.e PC's, games, TV, microwaves (:D) etc...
But deep down I probably aproach...
May 14, 2008 at 11:52 pm
jeff.williams3188 (5/14/2008)
The best way to shrink is: DON'T. Size your database and log files appropriately and expand them as needed.
Hi Jeff,
Will backing up the transaction log not also...
May 14, 2008 at 11:43 pm
Is the cost of drive space higher than the cost of the database being offline?
May 14, 2008 at 7:49 am
Gareth, you should be fine with either one. Just read up in Books Online for syntax etc.
May 14, 2008 at 6:06 am
What's the size of the database? Transaction log file?
You can create a job that backs up the transaction log, say, every hour... Depending on the amount of transactions, the backup...
May 14, 2008 at 5:33 am
Nice... I'm writing one next week :unsure:
May 14, 2008 at 12:21 am
I'll only write on topics that I have experienced extensively.
Being fairly new(1-2 years) to SQL also holds me back confidence-wise. I don't want to post/write something only to find...
May 9, 2008 at 2:33 am
Steve Jones - Editor (5/5/2008)
I'd suggest using the data export wizard, saving the package, and then adding the email task.
Exactly what I did 😉
May 5, 2008 at 9:58 am
Gordon (5/5/2008)
May 5, 2008 at 9:00 am
Hi Dave,
Have you tried using Integration Services?
I did something similar & it's pretty reliable.
May 5, 2008 at 8:48 am
Viewing 15 posts - 76 through 90 (of 104 total)