I am using SQL Server 2000. I backup database dbA in machine A. I would like
to restore this backup in another machine (machine B).
In Machine B I map network drive to machine A (say to drive X).
So, in Enterprise Manager on the SQL Server for machine B, I created a

I need to get some help with my T-SQL statements.  Basically, I have
the follwing
data in a SQLServer table and it looks something like this:
Current data:

Hi I am using mssql 2000 and have been performing a data port manually that
consists of running a query on an sql database (using a date range as an
input) and then connecting to an Oracle database and appending a table in the
Oracle database with the data from the SQL query.  ...

I have trouble to bring back SQL Server Databases that I backed up/detach from a SQL Server 7
installation.
In SSMS I click Databases, Attach choose the database to attach and click Ok.
SSMS successfully attaches the database but the object explorer shows: 'MyDatabase (6.5

Unable to log into remote Sql Server through a local machine using Visual
Studio 2008.  I received  the following error message:
"A connection was sucessfully established with the server, but then an error
occurred during the login process. (provider:TCP Provider, error:0 - The

If i need to query the system databases to find out witch database is in
suspect mode, what would be the tables and the field of the value? thanks

does anyone know about these tables on msdb: backup_movement_plans and
backup_movement_plan_database? Are they related to log shipping jobs? When we
create the log shipping jobs(copy and load) using script, how the data in
those tables get populated? and how the job know to ...

Hi Freinds,
SQL 2005 SP2
How can I grant only trace permission for a user? He needs to be able
to run profiler. I can't find Trace Role.

    I hope that I'm in the right place! Apologies if I'm not. Hope theat
you can help me with this one as I'm stuck. I have a table in a SQL
Server 2005 database that contains 3 columns. The first is a key, the
second the timestamp when the row was written and the third is the

Anyone know how determine how many new records ( or insert statments)
are occuring in a spefic SQL Server 2005 database.   I have been
working with the profiler and trace tool to try to find this
information, but no luck so far.  Thanks!

    I'm trying to add an int type to a datetime type to produce a
datatime type that interprets the int as *minutes*, for example:
2008-03-20 15:36:09.920 + 10 = 2008-03-20 15:46:09.920
    Problem is though - I'm stuck. Whenever I try to do this SQL Server

How to write SQL to find the Recovery Model type.
Please suggest me something.
Thanks, Steven

I'm trying to get a SQL Agent scheduled job working using the Schedule
Type of 'Start whenever the CPUs become idle', but it doesn't seem to
be working.
I setup a maintenance task to check db integrity (as a test), set it

I'm running SQL 2005 on Win 2003 Ent SP2 box.  Intermitently I get the
following messages in the application log.  When the warning occurs system
resources cpu, memory, and disk IO increase substantially and after about
5-10 mintues things return to normal.  This causes the ...

Why is it that when I create a varchar column in a table through the
SQL Server 2005 Management Studio and assign it a length of, say, 10,
when I tab to the next field, the length is changed back to 50? If I
return to the column type field and correct it, it works fine.