Viewing 15 posts - 1 through 15 (of 28 total)
plenty of example scripts on this site you can tweak to meet your needs
try this one
February 22, 2012 at 8:45 am
Can I assume you followed the steps listed in this article?
http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx
November 14, 2011 at 2:31 pm
I am also having this issue with 2008 SP1. I can add users but not groups.
October 13, 2011 at 9:58 am
it looks SYNONYMs may be my best bet for this as you can create then via script for each environment. You can create a "short name" for each table...
October 11, 2011 at 3:03 pm
can you explain further about the login script method?
July 16, 2011 at 8:04 am
You can have an active/active you just have to give them unique names. You can have one default, sort of, instance with no instance name.
so instead of:
MACHINE1
MACHINE1\instance1
MACHINE1\instance2
you'd have to...
July 5, 2011 at 3:10 pm
this returns the details of the SSMS report. Not formatted as nicely unfortunately
USE MASTER
GO
exec sys.sp_help_log_shipping_monitor
May 6, 2011 at 12:49 pm
Oh no, you said "kerberos". :w00t: I was afraid of that when I noticed no authentication was being passed but I was hoping it was something I could do differently...
November 5, 2010 at 8:07 am
different accounts in the same domain group. the domain group is a sysadmin on each server.
November 5, 2010 at 8:03 am
This is still 95% his code but I modified it a little to work with databases that have schemas other than DBO. It also uses the newer 2005 tables...
November 2, 2010 at 2:30 pm
This is an example using the PatIndex. I believe it's just one of many options but will work. Just add this WHERE Clause to your statement to return...
October 13, 2010 at 2:02 pm
This one walks through each database, non-system, and changes the owner. You should simply see a list of your databases it executed against in your output.
I would...
September 9, 2010 at 1:55 pm
I agree you should know your application before you do this. In most cases this should not cause issues especially using SA. That is unless you have SQL...
September 9, 2010 at 1:53 pm
I have received this error twice in the last couple months. I also could never track down a root cause. The only thing I noticed is my server...
March 24, 2010 at 9:10 am
Viewing 15 posts - 1 through 15 (of 28 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy