if you can connect as an admin, just reset the password;

otherwise, you have to restart the service in admin mode and follow the steps here:

http://beyondrelational.com/blogs/chintak/archive/2010/07/20/sql-2008-r2-new-installation-and-login-password-unknown.aspx

remember, we are on the other side of the interwebz here, and not looking over your shoulder. you've been looking at the issue for hours, and we onyl see three...

something to keep in mind: system databases cannot be restored from previous versions or servicepacks;(regular databases are no problem)

so say you backed up master, msdb and model in RTM (release...

yeah but your answer is actually better; least amount of access is the best;

my example was for...

ok, what you want is possible, but it's the wrong way to do it;

access should be handled via roles, and not at the dml trigger.

it's much, much easier to create...

ahh, since it is parameterized, what are the datatypes of @PolicyNo and @EffDate?

for parameters, you do not need the quotes if the parameter is the right datatype...maybe it's...

i'm not an SSIS guy by any means, but a script task that hits the extended stored procedure xp_logininfo might be a little easier:

EXEC master..xp_logininfo @acctname...

another option is this suite of CLR export functions I created and put on codePlex as a proof-of-concept:

https://sqlclrexport.codeplex.com/

here's the example code of exporting a table to a CSV report:

EXECUTE...

are you sure excel even supports a show / hide collapsing functionality?

I've never seen it; i think that is a property of html pages only.

this is a working, tested example of openrowset on an excel spreadsheet for a 64 bit installation of SLq server.

you need to know the name of the spreadsheet in the...

well it seems pretty easy as i'm slapping together a CLR;

gota basic syntax issue for when it comes to full file names:

for the switches, do any of these look correct?...

another quick question:

pgp --decrypt report.doc.pgp --passphrase Pa55w0rd

does that create the file report.doc or return a bytestream/filestream?

maybe there is an optional param for output file name like the encrypt command?

lol I'm the opposite, clueless when it comes to PGP, but well versed in Sql Server, .NET and CLR.

can you give me a pair of examples on the command line...

it sounds like you are looking for a CLR which can encrypt/decrypt a file to disk using PGP;

my Google-Fu pointed me to this thread from 2007 about SecureBlackbox , which...

the count of table rows are materialized in sys.indexes, and are accurate for the heap tables or clustered tables;

that's the way to count rows quickly:

SELECT so.[name] as

...