I installed SQL Tools on my Vista computer so I can connect to the databases
on our SQL server.  Everything was working fine until I had to change the
name of my computer.  After the name change, I get the following error at
boot up:

I've SQL 200 server in SBS 2003 server, after I set up a DB maintaines plan
which run every night.
But in the morning I saw the job log that shows me failed ( Status)
How do I fix it or run it again??

What ports do i need to unblock on client and server (running msvsmon.exe)
to debug remotely from my client box with visual studio 2005 pro?
When I attach to remote process a connection shows up in msvsmon.exe on the
remote machine, however, the client box with visual studio ...

I have about 1000 profiler trace files that I need to load into a table. Is
there any way to do a mass load? I know I can open each trace and do a "save
as" and then save it to a table. I want to do more than one table at a time.

do I need 2005 64 bit on my workstation to access/administer a 64 bit
sql2005 server?

I want to have profiler run for a period of time - 5 minutes - when system
cpu exceeds 90%. This would happen automatically. Can this be done?

I have a Database on SQL 2005.I want to trace what all changes were made in
this database on a particular date. A kind of report that will highlight all
changes made to the DB on that date. How do I acheive that ? Please advice.

how can I show the parameter (input/output) values that are passed into
stored procedures, from both client side and nested stored procedure?
Many thanks in advance
Eugene

Does someone no a good query formatting/align tool?
So it reformats sql queries ( indent, key words in upper case, line breaks,
....)
Thanks,

Our SQL 2005 Server software is installed on one of our Win2003 servers.  Can
anyone point me in the right direction for installing the necessary software
on my network client PC with Vista Ultimate so that I can manage the SQL
Server from my office?  Please forgive me if I'm not ...

My system is running XP Pro ver 2002 SP2 and I have SQL2000 and
SQL2005Express installed.  When I run SQLCMD from a Command Prompt I get an
error:
Hresult 0x2, level 16, State 1

Does SQL Server 2000 provide the ability to debug a nested SP or a trigger?
Can a watch be set and when the SP fires regardless of which user initiated
it a debug mode UI be displayed. If SQL Server doesn't provide this
functionality are there any tools that do. Compuware ...

Questions about creating an ‘executable’ that will not remained installed
once a user enters some data into the application. I also want this
applcation to not require any previous software installed on a users
workstation.

We have a really big query - over 50, 000 insert statements in an sql file
as a result of a data migration.  Both osql and Management Studio throw an
error in running the query file unless we break it down into smaller chunks.
So I have two associated questions:

A dump of our database is growing more huge by the week, but we aren't doing
much with it.  Properties show it us about 13gb in size, but the dump three
weeks ago was 26gb, and today it is 41gb.  I dumped tran with no_log and ran
shrink, but that didn't seem to do anything.  ...