I want to bring up the following data for groups:
Blue, Red, Green and Yellow.
I have the following view in sql 7 which brings up the data i want,  How can
i bring up the data for the other groups within the same query.

Is there a way to reload an ASP.NET web page each time a new record gets
iinserted into an SQL database table?
Thank you i advance,
Hrvoje

I have a SQL Server 2000 running on win 2003 where there is Linked Sever.
Recently we have upgrade the SQL server 2000 to SQL 2005 and things were
fine but suddenly one day things stopped working when I have tested the
connection for link server. It failed and gave me this error. ...

Gurus,
Running SQL server 2005 SP2 configured for Windows Authentication on a
two-node cluster running Windows Server 2003 SP2 inside a single Active
Directory domain.   All users logon to the domain from their Windows XP Pro

I have purchased a dedicated server from GoDaddy.
Ive installed MS-SQL Express 2005 to be used for an internal application.
Windows 2003
Firewall Turned Off (just until i figure this problem out)

I'm experiencing a very odd data loss in my SQL Server 2005. Some data
records have just gone missing (about 140 rows in one of the tables) and I
can't see any pattern. Also it seems to be, that this problem affects only 2
tables but I'm not sure about that since I haven't ...

SQL Server 2000 Standard
I need to move multiple databases (about 20) from the C partition to the E
partition. I'm familiar with sp_detach_db and sp_attach_db scripts and is OK
for a handful of databases but tedious with 10 or more databases. My manager

Is there an automated way of having SQL delete backup jobs?  I ran
sp_delete_backuphistory against the msbd database in SQL Server 2000
8.00.2039 and I had to stop it because it was taking forever to run.
I'm surprised that SQL does not automatically delete backup history since

SQL 2005 SP2 on Windows Server 2003 SP2
SQL 2000 SP4 on Windows Server 2003 SP2, with SQL 2005 Native Client installed
Some of the servers running SQL 2000 are using a 64-bit OS, some are usiing
32-bit.  All use 32-bit SQL 2000.

What happens if I cancel out in the middle of a log restore?  Would I have
to restore from a full backup in order to recover the database?  I'm just
asking because it appears to be hanging at 30 Percent.  Is there a way to
check if it's still doing anything.  Sp_who shows that ...

I receive Emails notifications for everytime someone enters their info
in our web form.  Would I be able to setup SQL Server 2000 to import
the data from that email into a SQL table?  What would the script look
like for capturing that email and executing the import?  Here's what

My database is on a hired shared server, where the use of BACKUP DATABASE is
prohibited.
Therefore I need to copy the database to my own server using DTS -  does DTS
have a different name in SQL Server 2005? - and then run BACKUP DATABASE to

Hi, i have a problem:
I have a .bak file from a database backup, but i don't have the database
anymore.
How can i create the database from the backup file?

I have a SQL Server 2000 instance on a Windows Server 2003 cluster.  The SQL Server instance is at SP4 with the
additional hot fix for the AWE memory problem.
We updated the OS memory from 4 GB to 8 GB but Enterprise Manager is still showing only 4 GB of RAM.  Task Manager on
the ...

I'm using SQL Server 2000. I've created a local package which runs
fine when i execute it manually from Enterprise Manager, but
constantly fails when I schedule it. Can anybody suggest why this
might be?