Viewing 15 posts - 8,341 through 8,355 (of 9,720 total)
I'm new to this myself, but I'll take a stab at the answer.
I don't think there is a real criteria. I think it depends on how you want your numbers...
April 29, 2009 at 11:20 am
Cursor is your best option here, then. Use the below code to get your list of database names. Use the FETCH statement against this list. Plus, add a variable that...
April 29, 2009 at 4:35 am
murthykalyani (4/23/2009)
Can't you create / extend file on new drive if you have?
You don't need multiple filegroups to put files on different drives. Just multiple files themselves. They can all...
April 23, 2009 at 5:10 am
Jason T (4/7/2009)
So now I have a new question - is it bad design to build a database primarily on the PRIMARY file group?
Depends on the database. We...
April 23, 2009 at 4:38 am
Neeta,
You still having this problem?
April 23, 2009 at 4:34 am
sriram979 (4/14/2009)
After getting all the error rows just keep an aggregate transformation task.
< blink > I didn't even think of that one. Thanks! I'll give it a try.
April 23, 2009 at 4:32 am
Check whichever port your endpoint uses. If it's the default (5022), check that. But there is usually 2 ports involved (ISTR) in the creation of endpoints, so make sure they...
April 23, 2009 at 4:14 am
Danb7183 (4/22/2009)The db_datawriter & db_reader gives the 'users' that are external to the domain all the rights that I believe they currently have (i.e. right to connect, add, delete, modify...
April 23, 2009 at 4:12 am
Glad I could help. @=)
April 21, 2009 at 11:13 am
Just went back to my old "Upgrading DBA skills to SQL 2005" book.
Before establishing a mirroring session, you must configure the communication mechanism through which mirroring will occur. This involves...
April 21, 2009 at 11:09 am
Ah, yes. You're absolutely correct on that. @=)
April 21, 2009 at 10:46 am
If it's an Active / Passive cluster, Steve, there won't be necessarily be multiple instances. One instance that swaps back and forth between the cluster as it fails is the...
April 21, 2009 at 10:34 am
Gift Peddie (4/21/2009)
April 21, 2009 at 10:30 am
Dan,
I'm a little confused. Are you trying to create logins on a user-by-user basis or on an application-by-application basis?
I previously thought you were talking about the later. Now it sounds...
April 21, 2009 at 10:25 am
Mackempete (4/21/2009)
April 21, 2009 at 8:54 am
Viewing 15 posts - 8,341 through 8,355 (of 9,720 total)