Use replace function.

select replace ('PQ19188PFAA','H','')

--create the table

create table logspace

(

dbName varchar(255),

logSize decimal(18,5),

logSpaceUsed decimal(18,5),

status int

)

-- create the procedure

create procedure logsp as

dbcc sqlperf(logspace)

--put all these into job that's scheduled to run every 5 mins or so..

truncate...

I thought sql server licensing is based on number of CPUs AND/OR number of clients AND/OR number of devices...

Ref http://www.microsoft.com/Sqlserver/2005/en/us/licensing.aspx

We...

Restart the service Windows Management Instrumentation

Ref:- http://sql-articles.com/blogs/connection-to-the-target-machine-could-not-be-made-in-a-timely-fashion-sscm/

On very large tables, updating the table in batches is the best way to avoid blockings. I'd go with Lowell's suggestion to update your table in batches. You can definately...

am (7/10/2009)

---

The concern I have here will there be any contention if all the indexes of these large tables for 9 databases read from the same drive. Also is the...

S Hodkinson (7/8/2009)

---

We have TSM backup which backs up every server every night. This overwrites the SQL backup full database backup so there is no start to the restore...

query backupset table in the msdb to see if backups are happening. Also, are you taking transaction log backups too using the maint plans? there may be some databases which...

Glad it worked 🙂

there must be some setting(s) but i'm unaware. I'd seen a similar situation in the past and this trick worked. sp_repldone too wasn't helping a bit.

Some activity is happening at night that's consuming heavy log file space? I suspect it's index rebuilding?...

Why dont use plain xp_cmdshell instead to copy the backups to different location?

These URL's will tell you how to enable this command(if not already enabled). Use plain DOS command to...

This happens usually when u restore replicated database. Try setting up replcation...

BOL=Books Online. It is the sql help book that is installed with the sql server for all editions except express edition. It's installed locally and is the best place to...

since the amount of data is very small, snapshot replication would suit you i guess as it would not pose much overhead in mainining it.

If you compare this with sending...

U said you dont hv problems getting microsoft products. I'd suggest install sql server developer edition and start learning by yourself to get yourself to some beginner level.

You can...