Hi

Can you post sample input what you are giving, so that it would be helpful to sort out the problem

Thanks

Parthi

Hi,

The following will work, but keep in mind that the information in sys.dm_db_index_usage_stats is only since the last service start.

SELECT t.name AS 'Table',

SUM(i.user_seeks + i.user_scans + i.user_lookups) 'Total...

Hi,

After Switching to the Simple Recovery Model

If you switch from the full or bulk-logged recovery model to the simple recovery model, you break the backup log chain. Therefore, you back...

IF EXISTS (SELECT * FROM dbo.fileinfo U INNER JOIN dbo.[File] A ON U.filename =A.filename )

BEGIN

Select ' First '

...

tshelly (9/29/2010)

---

CREATE PROCEDURE usp_addusertest4

@shusername varchar(35),

@shdescription varchar(50),

@shopid varchar(3),

@shadmin varchar (1)= '0',

@shehshop varchar(2) = 'AU',

@shstoreroom varchar(1) = 'A',

AS

BEGIN

INSERT INTO FASTER.sheader (shusername,shdescription,shopid,

shadmin,shehshop,shstoreroom,

VALUES (@shusername,@shdescription,@shopid,

@shadmin,@shehshop,@shstoreroom,

2. INSERT INTO Table 2

INSERT INTO faster.SAttribute (sashusername)

SELECT @shusername

So...

What error did you got i did not get any error

see this

declare @fileinfo table ([FileName] varchar(10),[RowCount] int)

declare @file table ([FileName] varchar(10),[RowCount] int)

insert into @fileinfo

Select 'A',1

insert into @file

Select...

sandy-833685 (9/27/2010)

---

Hi i am having table with column name time data type as datetime

And when i try to execute the select statement with convert like

select * from tablename

where convert(varchar(10),time,103)<'06/06/2010'

as i...

imraanm (9/27/2010)

---

Parthi hi,

THank you for the reply. I have tried the script, and still not luck. Doesn't display the desired info.

Perhaps if you have a script to audit all the...

imraanm (9/23/2010)

---

Im new at sql...

We have a sql server 2000. SQL Profiler is not running on this server.

I need to info on/audit all scripts that were run (successfull or...

nari.koud (9/21/2010)

---

Hi All,

I have Database DB and Table CB ..CB has 3 dependent Tables OB ,CP,CI

So My Requirement is ..

delete From CB

where ID_NUM not Like '99%'

But...

david_wendelken (9/21/2010)

---

I've been re-formatting ola hallengren's sql maintenance script so I can read and understand it before trying it out on a development server.

It has a command I don't understand.

Is...

Ghanta (9/22/2010)

---

Thanks Parthi this is what I had planned to do... I convinced my lead that we do not have to use bitwise... I am on the track now. Thanks...

Declare @VendorName1 Nvarchar(max), @FileType1 Nvarchar(max) , @Database1 Nvarchar(max)

Declare @VendorName Nvarchar(max), @FileType Nvarchar(max) , @Database Nvarchar(max)

set @VendorName1 ='Test1|Test2|Test3|Test4|'

set @FileType1 ='File1|File2|File3|File4|'

set @Database1 ='Database1|Database2|Database3|'

Select CHARINDEX('|', @VendorName1), len(@VendorName1)

While len(@VendorName1)>0

begin

Select @VendorName = substring(@VendorName1, 0,CHARINDEX('|', @VendorName1))

Select...

You might not be having field name called Score in any of the following tables

view_active_advertisers

tbl_advertiser_category

tbl_advertiser_section_data

Can you post that sample code so that it would be bit easy to get through

Thanks

Parthi