SQL 7 and 2000 have a limit of 32767 databases per instance. I don't think anyone ever reached this limit. So in your case I suspect that the server hardware...

The files are stored in Program files\MS Sql Server\90\tools\binn\VSshell\common\ide\sqlworkbenchprojectitems\sql

If you add the files directly to this location, you need to restart SSMS before they are visible. And yes, the extension...

CTRL+ ALT+T brings up the Template explorer window. There you can add your own templates.

Markus

Do you have ASp.net installed on your IIS ?

That's a requirement for RS.

Markus

Since your input is a xml document check out sp_xml_preparedocument.

BOL has some examples.

Markus

Sorry Bob,

I can't duplicate your problem. When I select an existing table as the destination, Create table isn't even an available option. Are you sure you've select the correct destination...

Lance,

you might need another driver to connect to the 64-bit server. I heard last week from MS that ODBC is not supported for 64-bit version.

Markus

James,

look in BOL for sp_start_job.

Markus

You can add the button in SSMS. Under Tools, open customize. You find the button in the Window category. Just drag and drop the icon to your menu bar.

Markus

David,

as far as I know only a trial version can be downloaded from MS Download center. Maybe if you're a MSDN subscriber,you can get a full version, but my subscription...

You could use xp_regread or if it's a named instance xp_instance_regread. But be carefull using them, since they are undocumented procedures and act slightly different for 2005.

Markus

First I like to agree with Andrew. Defragging the datafiles will improve performance only in very few cases. I had to deal once with a database file which consisted of...

Maxus,

without knowing what you actually storing in this table it's hard to tell if you can optimize it or not. Anyhow at first site it looks ok, but the real...

Thank you david,

I knew it was something simple, but sometimes you just don't see it.

Markus

Oeps,

I just realized that you posted that in the SQL 2000 discussion. But marking the proc as system object will solve your problem.

Markus