I have a simple SQLCMD batch file that should execute a SQL query (via input
file) on two servers.  However, it produces an error.
Batch file contents:
sqlcmd -S Instance1 -E -i serverinfo.sql

I can add a remote server connection in SQL Management Studio. But it seems
that I cannot successfully add a remote server connection in SQL server
Business Intelligence Development Studio on my local computer.
In Intelligence Studio, in server explorer I click server -->add ...

I have a busy SQL 2005 dB with about 6 gig of data. I had recently moved it
to a new server and neglected for several weeks to add a maintenance plan to
backup the tlog. The server environment is an active/passive cluster with an
iSCSI NAS holding the data.

For deployment purposes, our IT department has allowed us to send an mdf file
to 'attach' to their server in the interim until our own server gets built.
This development database that we're building does not have any 'user'
writes to the database, i.e. only DTS will add data to ...

I've created several database maintenance plans and I create the schedule
within the database maintenance plan.  This creates a job name the same as
the database maintenance plan name with the subplan name appended.  When I
open up the job schedule properties within the database ...

My database uses several schemas (catalogues).
How do I create a new table in schema other than default "dbo" using
Management Studio ?
If I specify a name like "myschema.testtable" saving a new table it creates

How do you copy a table from one database to another database using SQL
Server Management Studio Express for SQL Server 2005?  I was able to do this
easily with the Import/Export function in SQL Server 2000 but have failed to
find the equivalent in SQL Server Management Studio ...

Am trying to install the SQL 2005 Upgrade Advisor.  I got the installer as a
download from the MS site, but the package won't run -- I get an error
message stating that the installation package could not be opened, and that I
should contact the application vendor to verify that ...

Using SQL 2000, SP4. My ERP Vendor has provided me with a large T-SQL script
that reindexes all tables in the ERP database. I need to run it weekly. It is
too large to copy/paste into a new DB Maintenace Plan or a new Job. Is there
a way to "call" this script to run at a specific ...

I'm trying to do a BULK INSERT with an XML format file. I get the
error:
Line 30 in format file ...: referencing non-existing element id "21"
If I run BCP against the same format and table, I get the error:

We are getting a failure on a Optimization Job for a DB Maintenance
Plan.
The event log states a 208 error with the Job Engine.
The Job History is:

Can anyone help me with how to run a DB shrink? How do I do it where do I run
it?

I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition
(downloaded and ran the SP2 Update), Visual Studio 2008. VS2008
installs no problem. When I install SQL Server 2005, I get an error
when it trys to install the last part( Workstation Components,

How do I find what the predefined rules are?
When a scan is run, what exactly does it do?

I had thought the SQL Server 2005 Scripting was completely hosed.
But while working at a Clients I ran into an Isntance of SQL 2005 that
Allowed me to Generate individual files for every object with drop and
create in each script.