All of a suddent yesterday morning one of my DEV SQL Boxes started reporting
MSDB as suspect. I tried to follow the instructions outlined in
http://winzenz.blogspot.com/2006/09/fixing-suspect-sql-databases.html to
restore MSDB, however when I try to start sql server using the ...

Hi --
I am looking to migrate an old application built with ASP and running on SQL
Server 2000 to a RIA type app possibly using Java and SQL Server 2008. I
have been reading about SQL MetaData and I am curious to know if the

I have a Windows 2003 server with SQL 2005 Standard Edition sp1
installed.
I need to install SQL Server 2000 Developer's Edition.
Are there any tips or traps that I should be aware of?

We run an ASP.Net web application on a web server and this application
communicates to a separate database server to get its data.
Many customers access their information via this web server and each
customer has its own database on the database server.

  I turned on AWE and set a maximum to 28GB , but when I perform a select
statement , and found out the memory usage is extermely low
  I tried to observe a AWE usage base on query below , it show 0.
SELECT

on sql 2005, I want to grant a particular user (login) the permission to run
a single sql job and nothing else. Is this possible, and how to do that?
Thanks

In SQL Server 2005 Management Studio how do I include object permissions
when scripting out objects?
When I script out a role or user, all I get is the sp_addrole or
sp_grantdbaccess statement with no associated GRANT statements.

I'm running SQL SErver 2005.   I've created an SQL Alert for events of
severity 15 (syntax errors).
I created an Operator with my name.  I added my email and my net send
address to the operator.

Hi I'm having a strange caching problem with a UDF.  I have a UDF which takes
10 parameters...I call the UDF twice within a single SQL JOIN statement
because the UDF returns a TABLE. The two UDF's are called with slighlty
different parameters, the problem is that both calls ...

We have large partitioned table which has 14 partitions. Among other
columns, it has XML data type column. We have noticed that recent partitions
grew up significatnly, regardless of the fact that the number of rows
remained approximately the same (comparing to the old ...

I have experienced a timeOut problem while executing the following query:
How may i solve the "timeout problem"
RESTORE FILELISTONLY FROM DISK='S:\ProductCatalog.bak'
The error message is     Unhandled Exception:

I'm trying to shrink and oversized Log file. I've done a complete backup but
when issuing the shrinkfile command I get this:
Cannot shrink log file 2 (xxx_web_Log) because all logical log files are in
use.

I copied this command straight from the books on line and executed it in sql
2005 9.0.3068
ALTER DATABASE AdventureWorks
SET COMPATIBILITY_LEVEL = 90;

What is the proper syntax for moving a foreign key from one table to another.
My foreign key used to be a desciption. I would like it to be an integer
entity.
update Cat2 set Cat2.Cat1ID = (

I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can
I copy databases from SQL 6.5 to SQL 2000?
If not, I will need to install SQL 7.0. Will it install on XP Pro?
I have an install CD from MSDN but I can't find any product keys for a CD