We have two instances of SQL 2005 on an active-active cluster. No service
packs.
Each instance has its own drives for data, log files and backups. However,
when performing manual backups from Management Studio, the drives used for

a while back I created many tables in a new db, they were created
using the 'management studio' and the schema is 'zinquiry'
today's I created a new table, and its schema is dbo
how can I specify the schema before creating a table

I am trying to recreate a MySQL db on SQL Server Express.  I have the
create table and inserts imported to the Query Window on SQL Server
Express but I have some errors when I run the query.  My first
question is how to go to  the line numbers in the error messages so I

I am trying to add a new data source to a new project in Business
Intellegence Developmnet Studio.  When I do this I get the error:
class not registered looking for object with clsid
{4503861B-5694-45AE-94DD-BC6541316FB7}

When I run my T-SQL query in SQL 2005 mamagement studio, I get four output
messages (as expected)
10,000 rows affected
10,000 rows affected

We're using database mail (sp_send_dbmail) in SQL 2005 (64-bit) to e-
mail a dataset to a customer.
The procedure works perfectly with the major exception that the
generated e-mail is encoded in base64.   (To reproduce, use

We have a table with 300 mil records. We are planning to delete 100 million
of them on a production environment.
It's 24x7 db but we have a one time 8-hour OFFLINE window.
The existing night delete job (2 to 4 hrs) deletes by 500 chunks at a time,

I need a very basic SQL Server Express setup to connect to Visio
Professional to draw an ERD.  I downloaded Express and just followed
the default installation with Windows authentication.  The Server is
running in my Services.

is there any way i can check particular user permissions/roles on SQL 2000
environment?
thanks
Farrukh

i have an SQL query you may be able to help me with, on my website the
mailshots are stored in a table and then every recipient is stored in
a cross referenced table, most days there about 10 - 20000 people to
email, obviously over a long period of time the 'recipients' table has

Can someone please recommend 3rd party tools available to encrypt a database?  One of our clients has asked us to encrypt "the data at rest" and I am still trying to figure out what that means.  But perhaps some of these tools will give me an idea of what we can offer them.
The ...

I have been asked by my boss to work out how to get our existing ASP.Net
WebApp to allow authorised users to upload a number binary files (typically
pdf) to the system to be attached to their records.
The system is SQL2000 based at present.

I'm working on a time card system for employees, I'm trying to
calculate the difference between two time values,  one is a datetime
column (time_store.stamp) the other is a varchar column
(employees.contracted_to_time)

I am fairly new to SSIS 2005 (as is evident) and am trying to figure out how
to connect to a remote server on which to run and store packages.  Can
someone please help me with this procedure?

hi all - wonder if there is anyone out there who experiances what i am
experiancing? i run sql server 2005 on a machine with windows server 2003.
very small database collecting radius accounting data for about 40 adsl
users. the server has 2 gig ram on a 3ghz dual core machine ...