assuming the second table could potentially be the same size as the max for the first, it looks like a 30 gig database to me for just the data?

1.5Meg *...

it sounds like orphaned users to me, is that right?

for SQL users(not windows users)

if you restore a database from a different server, the user "Bob" on my server is...

that's usually handled by either the client application,...

you can only create a SQL user without login;

so CREATE USER [ClarkKent] WITHOUT LOGIN is fine and will work;

but if you put in a slash in the name, a windows...

i've used filezilla from a command line, as well as CoreFTP; both of which support SFTP and other protocols;

i think FileZilla is free, and I know we paid for CoreFTP.

https://wiki.filezilla-project.org/Command-line_arguments_(Client)?

can you edit the SQL Server(SQLEXPRESS) service, and change the startup account?

Change it form whatever is there, to your username and password, for example, and then start the service?

I have a certain fondness for doing solutions in TSQL, or at least be centered around TSQL, regardless of whether it's the right tool for the job or not.

I...

killing a linked server action that is using a distributed transaction pretty much guarantees a reboot is required to complete the rollback.

it depends on what the query is actually doing...

first, lets make sure you know the name of the instance, and the instance is actually running.

It's quite possible you installed the Tools but not the service itself, or the...

pretty sure RAISERROR requires three parameters, and you only passed one.

RAISERROR ('Duplicate Records',16,1)

i believe functions that are not CLR functions must be prefaced by the schema:

SELECT

Address1,

Address2,

dbo.FNCNOTAVAILABLEDISPLAY(Address3)

FROM Customers

this link says the function is part of 2008R2 SP1 or later:

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/250ee9a5-e851-4449-b279-165fe0ccd600/

if you run the command in the master database on the server that seems to fail, does it work?

CROSS APPLY for a function will fail syntax if the database compatibility...

saving rtf text, or saving it inside a document(like word) which supports font formatting are the only other ways i can think of.

AmarettoSlim (5/22/2013)

---

Resurrecting this thread with a question I have...

Can someone explain why SQL Server doesn't support object level recovery in a native manner?

How do 3rd party vendors make this possible?

I'm...