I agree with Pradeep ; the issue appears that the service is not running.

log into the server, go to control panel/Administrative Tools/Services, and try to start the SQL service again....

Just for fun, I wanted to try this out; I had "Recover4all Professional 2.25", some old undelete program I used to recover some files a while back.

I created a database...

not in the exact same operation, but you can use one backup to restore/create as many databases(each with a new name) that you want.

whether from the GUI, or via...

i believe i saw thread which stated that openquery against a linked server was faster for a linked server vs a query on your server using 4 partnaming conventions;

for example,...

it should work with some minor tweaks:

after you've done the DECLARE @acumul_error varchar(100) or whatever it is, you need to initialize it as an empty string:

SET @acumul_error =''

in the...

here's another option;

you can create a linked server for a Folder on the server, and each text file becomes a table. every file that is comma delimited can...

both are views of course, created to help pull information about the metadata together.

the data in the two columns will often be the same; Information_Schema is a standard format...if you...

wrap any object name with brackets(or double quotes) if it doesn't follow normal naming conventions, has spaces in it, or are the same as a reserved word:

select * from [170703-test]

or

select...

this is most likely the error:

if the table accountinfo has two or more rows, then you'd get the error you describe...maybe you need a WHERE statement to limit the rate...

Thanks Michael and Robert;

I was stuck thinking I could append the default at the end, like i've done with PK/UQ/FK and check constraints.... instead of still part of the column...

it was just an example so i could get the named default constraint in there somewhere ...i didn't really think it through;

there's a lot of inner joins...which part do you weant to change into a subquery?

formatted for readability...the exisitng SQL made my eyes cross:

SELECT DISTINCT

Auditdata.ID,

ns.ProviderMaster_ID...

note that there are THREE places you can change collation at the server level, for each database, and then again for each column that is of type varchar/nvarchar/char/nchar/text.changing the...

As Far as I Know, there is nothing that has a mapping that says viewname.column1 comes from tablename.somecolumn3;

obviously reading the code itself might help, but remember the column could be...

Trout (7/14/2009)

---

I have tables in one database with a link being user_id field to other tables in another database.

how do you connect two different databases to one query.

ie databaseA and...