here: http://www.mssqltips.com/tip.asp?tip=1714

you can find following informations:

AUTHENTICATE SERVER - Grants or denies the ability to use a particular signature across all databases on the server when impersonation is used.....

hi mjarsaniya!

are you running 32 bit windows or sql ?

why? because sql love memory 😉

you can use server properties to limit memory usage:

SSMS -> object explorer -> Right click on the server -> Properties -> Memory page

there are:...

a common and good practice is to use windows authentication and just disable their accounts.

Sean? and the problem is ????? maybe some more information ?

some people dont install any kind of mgmt software on production servers... (SSMS/BOL ...)

is it right? it depends.

why you can't use dynamic sql + linked servers ? it looks much easier..

1) select from table: my_magic_value; linked_server_name

2) use proper linked server during building query

3) fire it!

Paul has right (as always ?:P)

Sharepoint's database have by default FULL recovery model turned on.

during setup you have to choose SQL_Latin1_General_CP1 + Case Insensitive and Accent Sensitive

default collation depends on server's regional settings

if you dont have properly configured replication you dont have distribution database; but you can set default data/log path. sql will use them after create distribution database

select convert(bigint,convert(binary(8),3000000001))

DECLARE @i BIGINT = 3000000001

select convert(bigint,convert(binary(8),@i))

in this case sql server has some problems with guessing datatypes - if you will use smaller number i.e. 1234567890 both queries return same...

user activity? maybe some unfinished transaction ?

all you need is to install .net framework 3.5 (you can find it on net or cd wich sql)

in sql 2005 (and specially when during using snapshot isolation level) very important is tempdb performance (separe disks, raid 1/0/10 and so on...)

like other people are saying ... documentation and naming convention all you need 😉

i.e. naming procs similar to reports and so on...