i've had trouble like this before, it was down to permissions, detaching a database usually in single user mode locks the files to the user who detached it, so trying...

I no longer work in the company where I used Sybase so I cant find the setting in the DSN for you, but I know it wasnt something which said...

on the flat file source, specify " as a text qualifier to have SQL strip out the " on the import

use ssis to dump the data into a table or the import export data wizard, then you can query the table with the data

I fall in to this trap most of the time as well, never remeber to restart the Agent to get it to pick up the mail profile

I don't think there is from within SQL itself, but you could write a WMI query which polls the service and sends an email out when its stopped.

something along the...

Doh, should of said sp_dropserver, but I guess you knew that

Ummmm.... thats a good one, saying a kick is to drop the DB or a table in the video, I am guessing that dropping down will issue DROP SERVER or...

Firefox has issues with authentication and always prompts for usernames and passwords in my experience as I believe it doesnt handle the kerberos authenitcation like IE does.

Using IE always automatically...

what browser are you using when trying to get to your SSRS web page?

have you run through the reporting services configuration wizard end to end?

another factor as to acceptable loss of data and spending etc is your RTO, you need to know that with your backup routines you can recover within your RTO as...

doh, beat me to it

a bit crude, but you get the idea

create table a (a varchar(10))

go

insert into a values ('123abc');

insert into a values ('1023');

insert into a values ('12dcrttg');

insert into a values ('frtgwef');

insert into a...

Believe this to be a duplicate post

http://www.sqlservercentral.com/Forums/Topic1197945-391-1.aspx