if you hadn't already said that you were on mixed mode authentication id'd swear that you were on windows only auth

by the way - is the server a member...

if you're attempting connect remotely is this via you LAN or are you coming through the internet via VPN?

i've seen this problem with juniper before.

do you have a firewall installed blocking your sql ports ?

DBCC SHRINKFILE WITH TRUNCATE_ONLY doesn't break the LSN (log sequence number) and cause you to lose your backup chain - all it does is remove the empty space from the...

you can find the contents of your file dsn's at c:\program files\common files\odbc

you can then edit one of them and add the PWD=mypassword or PASSWORD=mypassword line to the file

firstly it might be wise to run the following

use mydatabase

go

dbcc updateusage

go

that should make sure you get accurate sizing information

then run sp_spaceused again

to view which tables are using the most...

sounds about right

in that case i recommend 3 maintenance plans 9the easiest way to implement that

one for system databases

one for user databases in simple recovery mode (no t-log backups)

one for...

if you're running a query then the statement

execute as 'mytestuser'

execute as self

execute as caller

might help

look up "execute as" in books online for more details

it's easy using a file dsn - but as i remember (unless anyone can contradict me) impossible with a userdsn

you need to speak to whever supports you email - but it looks like since your mail is via the internet it will only "send and receive" when you open...

you've come to the reight forum for information

i'm guessing that you may not know about the recovery model for databases if you've been trown in at the deep end

in short...

tyy this

go to server 2005 menu on the start menu and find the sql server 2005 surface area configuration tool

under remote components ensure that local and remote connections are...

or this script

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=319

personally if it's data minipulation as a one off excel (spit!) has 2 functions - deleimeter to column - column to row - these can be used...

this is a mail issue and not SQL agent.

is your outlook mai (mapi) profile set up to connect to an exchange server on the same network, or is this...

you server could be set to use windows authentication only

go to 2005 server management studio, right click on the server,choose properties and then click on security - ensure it is...