Abhay (6/22/2009)

---

I want to take weekly backup of my database. Full database backup is required to be taken. i have created a job which takes backup on disk in...

you may want to add this part in ur query searching for tables

AND TABLE_NAME'Results'

------------------

SET @ColumnName =

...

what is the code you're using to search the database? do you have a full text search index on ur database?

I'm not sure if that happens but this is how you change a password.

ALTER LOGIN sa WITH

PASSWORD = 'new_password'

also how are the users updating the records? one by one or bulk updates? Do you have indexes built on the columns which are used for updation?

- proper indexes will...

NOLOCK hint is what i can think of. Reading can be done using nolock but beware of the consequences, You might read inconsistent data.

caselig (6/21/2009)

---

I first installed SQL 2005 Express, then .NET Framework, and then the Management Studio. All from the Microsoft site.

Maybe I should uninstall them. And then start over. ...

smsam1 (6/21/2009)

---

since i want only to show 't' or 'f' in upper case letters, i will use

select upper(flag)

from patient

...

if you've installed, it must be there or else it's not installed i believe.

How did you get the installation file(downloaded from microsoft's site? can u share the link from where...

if you're planning to take image of the entire disk, sql...

Pls post the complete name of the service as suggested by Gail.

Also, you cannot change the name of an instance without removing the installation and re-installing it or by...

Thanks Gail for detailed explaination. It certainly helped a lot.:-)

James, As suggested by Gail, you'll need to perform those steps(to rebuild transaction replication and delete it) for permanently fixing this...

Yes, very uncommon situation. waiting for Gail for her thoughts on this, on the probability of error chances :-).

Gail, I think he is running Transaction replication coz i asked him to make a transaction and it replicated to subscriber in almost no time. Also he told that his...

as as (6/20/2009)

---

I administer a dating website and we currently have two databases, one that basically stores user info and another that stores messages between users. The user info...