I am currently using SQL Server 2000.  I have a production database and an
instance.  The instance is mainly for web display.  What I would like to do
is when the production database has an insert or update a trigger, or any
other option, activates and inserts or updates the ...

I have the follwing error message when I try to create a Job in SQL Server 2005
"Unable to cast object of type
'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type
'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'.

Assuming I have 5 per server licences for SQL 2005 Standard Edition servers
and I had and 50 clients with SQL CALs I believe I can install SQL Server
Management Studio on any of these 50 client PCs to administer any of the 5
SQL 2005 Standard Edition servers.

Is it possible to import data from xsl SQL Server Express?
Clara
thank you so much for your help

Does anyone know if it is possible to schedule an automatic backup of sql
database through SQL Server Management Studio Express? I have heard there is
no job scheduler included with this management tool however i'm not sure if
it's possible. If it's not possible could you make a ...

Quick question. At my current job, we are looking to install an Access
frontend that connects to our main database. This would involve everyone
using the front-end to access the main SQL Server using a read-only user
account. The only concern is how this will affect performance.

I don't know why there is no Management Studio after I install SQL Server
2005 Developer Edition. Is something wrong during the installation?  If not,
where can I get the Management Studio?
Clara

I installed Visual Studio 2008 on a Vista box.  After Visual Studio loaded
SQL 2005, I try to install SSMSE, but it always fails with error code 29506.  
Anybody know what is going on?

If any body can suggest me on the following questions.
(1) Does SQLServer can extract data from Lotus Notes DataBase.
(2) What are the steps for migrtaion from Lotus notes to SqlServer database.
(3)How migration can be done from lotus notes to sqlserver.

   I'm not sure if I'm posting to the correct group, but I don't see
a microsoft group explicitly for data minig and I would think SSAS
falls under the category of a "tool" for SQL server.
   I have a mining structure set up with the intent of predicting

i know ssis allows to insert from a csv file into sqlserver (2005) tables
but is it possible to either update and/or delete records with an ssis
package based on a csv file?
thanks for you help.

Does anyone know if there are any outstanding requests on the Connect site
asking that the table designer in SSMS please stop automatically changing
varchar(10) into varchar(50) the first time you enter it? Am I the only one
this drives up a wall?

When I go to look at the securables in SQL Server Management Studio I get a
"Value does not fall within the expected range.(SqlMgmt)" dialog that comes
up. It seems to only do it on some groups. Anyone have a fix?

I have a table with more then 500000 records.
I'm trying to search for a part of word in a description-column (char50),
normally I take the like statement.  But sometimes it is too slow.
Does anyone have a solution for that ?

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly
takes 90minutes to do all DB's but on occassion it gets hung up.  The job
starts at 10pm, is there a way to check if it's still running at 12:00pm and
if it is notify on of the DBA's?