How do i send an sms using SQL server 2005 Notification services.
If possible i will need full details as I have only gone through tutorials.
Thanks
Sanjeev

Hi Everyone, hope someone can help.
I am running short of harddrive space and want to move a folder WSUS onto
another drive, is that possible without having to reinstall SQL
I am using SQL 2005 express.

We are using SQL 2005. I'm trying to setup an operator who can have more
than 2 emails, is that possible?
Otherwise, is there any other way I can notify at least 2 DBAs when the job
failed.

i have to install a trial version of SQL Server so i would like to know how
to pass to full key without reinstall SQL and keeping my configuration.

I am looking at how I would be able to use VS SQL Server 2005 projects,
however I am having difficulty seeing how I can build deploy to the live
environment.
As an example, I have an existing DB in production which I want to upgrade

So the best practice I see is to remove built-in admins from the sql server
logins.  
On the flipside, what is the best practice regarding DBAs being added to the
local server admin group?

Our company recently aquired a new company. Their SQL server doesn't
appear to be used but I want to be
completely sure it is inactive before turning off the services. What
is the best utility to use to monitor DB activity?

I am working on a presentation for the SSWUG SQL Server Confernce and I
noticed something in my Server Properties as I was checking on a version.
SQL Server says my Lap Top (my presentation machine that I run demos on)
says that I have 4 Gigs of memory on the machine.  But when I ...

can anyone explain to me what does this patindex('%,[0-9][0-9],',note) means?
i saw the patindex () normally take %pattern%, with % front and end, but this
one doesn't, so what could that means? the note field is like this , "
,L101,A101,01, "

I am running SQL2005 64bit SP2. I have setup a database role with
data_reader access to a database. I have setup users to use the database
role but the users can not see the tables unless I explicitally give the
user data_reader rights. Any ideas.

I have a complex spreadsheet with about 15 worksheets, which are all linked
together and a large number of macros.  I want to import all data and
functions into a sql database and eventually create a helpdesk application.
Can anyone suggest a way of doing this?

    We are using SQL Server 2005 Express edition.We encrypt data in the table
using asymmetric keys:
CREATE ASYMMETRIC KEY MyKey AUTHORIZATION dbo With  ALGORITHM = RSA_512
ENCRYPTION BY PASSWORD = 'wcixoOEb5h77gh5'

Everytime I starts Management Studio the password box is empty even I ticked
the 'Remember Password' box.
Any idea why it did not get remembered?

I am having problems with SQL Server on a clients website...
I know this email is quite long. I really need to sort out the failure
rather than anything else here. I add all other info in case it is relevant.
The site is built with C#. When I open a connection, I always close it. ...

hi
I have found a problem in link server
OLE DB provider 'OraOLEDB.Oracle' reported an error.  
[OLE/DB provider returned message: ]