Viewing 15 posts - 511 through 525 (of 816 total)
(a) The ability to *just* execute existing stored procedures, and to create (but not drop/modify/etc) databases
creat a group and give 'Grant exec' to that perticular group. Later on you can...
September 24, 2010 at 3:54 am
right click on your linked server, go to peroperties, go to general tab--you will see provider option.
Change the provider to 'sql server native client 10.0'
September 24, 2010 at 3:21 am
But I think, this is not answer for my question?
think again, your answer is already answered
Approach depends database to database.
the database which is being updated very frequently(kind of highly...
September 24, 2010 at 2:14 am
use 'sql server native client 10.0' as provider.
September 24, 2010 at 2:12 am
also in most of the case sql service are configured with windows account and that account need to be in domain users and domain admin account.
September 24, 2010 at 2:09 am
our production time is 5.30am to 11.30pm
if you have maintenance window available between 11.30pm to 5.30 am, then I will suggest check the job running on server and find the...
September 24, 2010 at 1:38 am
i have just read another very good article related to moving the database and advice you to have a look into it.
http://www.sqlservercentral.com/articles/Administration/65896/
article describe why using alter database is preferred on...
September 24, 2010 at 1:35 am
But could you advise how I can analyze/monitor the growth of the files? And also suggest ,is there any documents related to this?
if you google it, you will find the...
September 23, 2010 at 8:08 am
Approach depends database to database.
the database which is being updated very frequently(kind of highly OLTP database), % growth is not recommended. Its better to have autogrowth with fixed size* and...
September 23, 2010 at 6:48 am
you first need to analyse your index fregmentation,
in general if fregmentation is less than 30 then reorganize is preferred else rebuild.
online = on is mainly provided from 2005 onwards...
September 23, 2010 at 6:43 am
as you configuring, so it will be active-active-passive server and you need three well prepared server.
While shortilisting the hardware limitation, please keep in mind that at emergency your one server...
September 23, 2010 at 6:36 am
Two nodes means two physical servers(Yes/No)?
yes, number of node is number of server.
Each physical server having the separate sql server instances. am i right?
read this article thoroughly, very good...
September 23, 2010 at 2:08 am
My pleasure Dias.
Venky,
as mentioned in article:-
If you haven't installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility.
September 23, 2010 at 1:10 am
check the dependency of the table using :-
EXEC sp_depends @objname = 'tablename'
September 22, 2010 at 11:05 am
Viewing 15 posts - 511 through 525 (of 816 total)