I am creating new maintenance tasks for my 2005 server as we migrate from
2000.
In the "Maintenance Cleanup Task" the option "Search folder and delete files
based on an extension" doesn't appear to go through sub-folders. Since I

   We have a sql server serving for BizTalk in our staging environment
running under "Local System" account. To make the account privilege identical
to production environment, I'd like to change it to a domain account. I
wonder if there'd be any risks for doing that.

I am trying to debug a SQL 2005 dump file - I have the correct public
symbol path (it gets the kernel symbols, etc.) but for some reason it
cannot find the SQL symbols - what am I doing wrong here?
0:075> !sym noisy

I have SQL Server 2005 Standard on a Windows Server 2003 64Bit Operating
System, Dell PowerEdge2900 with 8GB RAM.
Once in couple of months, the SQL Server just stops responding for my client
requests which my application uses as a backend database.

I am looking for a Script which will give me complete space usage
information of a particular DB in SQL Server 2000.
It would be of great help if I get the script which will give same
results as we get in Database diagram.

I want to search for even and odd numbers using a SELECT query. I thougth
there was a MOD function, but cannot find information or examples with it. I
got a SQL Server 2000.
Thanks all,

Running Windows Application over VPN
I have a windows application that uses SQL Server as backend.I need to
install this application to another network and make our users access it. I
have two options:

I'm trying to enable AWE to access more physical memory for SQL Server 2005
64-bit. I am not seeing the "Address Windowing Extensions enabled" message in
the SQL server logs when I restart services. I am following SQL documentation
to do this but am having no luck. I have done ...

Hi everyone;
                 I want to write a report about database model, and i
plan to write 3 models which are Network Model,Hierarchical Model, and
relational model.

  I've installed a Visual Studio 2008CD and found out that the SQL is
installed as well,now i need to create a new datbase using SQL ,I go to
propgrams>SQL Server 2005>Configuration tools then i have three icons :
* SQL Server Configuration Manager.

Is there a way to create a script from the existing database, Adventure
Works for example? I mean, some way to export not only a table structure,
for example, but also data into a sql script, so that if I run it, it will
create me both table and insert all data. Is it possible to ...

If I have a select statement that produces no results, what sort of
locks could it still potentially generate?

  is there a default transactions timeout when running stored procedures?
Basically I need to run stored procedures that could involve 100,000s of
inserts\updates and I want to be able to let the procedure run until these
are completed. Is this feasible or are there some ...

I'm new to SQL server programming and trying to open a connection to
MS SQL Server 2005 from VB.NET. I created a new databse called lion;
thus in the browsing file folder window in "MS SQL Server Management
Studio Express" lion appears under "Databases"

I'm running a 4 node active SQL 2000 cluster.  Each server is running
Windows 20003 Enterprise with 16gb of RAM (server sees all of the memory).  
Each server has the "Dynamically configure SQL server memory" option enabled.
I'm not all that familiar with SQL and I assumed that ...