Are you using integrated authentication?

If you are we have a similar problem beacuse we are currently running in mixed mode security and not 2003 server native. This mean that delegation...

To solve this either go to layout and create a parameter called user and set the default value to User!UserID and then create your query as

WHERE Report_Security.UserID = @user

or...

I had a a similar problem and solved it by restarting the RPC service.

hth

Dave

The main difference is that DBCC INDEXDEFRAG is an online operation whereas DBCC DBREINDEX is an offline opertaion i.e. while re indexing you cannot access the table.

However you invariably have...

If i understand you correctly something along the lines of

SELECT CUSTOMERID, PRODUCTID

FROM TABLE

GROUP BY CUSTOMER ID, PRODUCTID

HAVING COUNT(*) > 1

hth

Dave

No you would just replace the mail stuff with

exec master..xp_cmdshell 'net send ....... '

Yes this is possible.

You could get it notify users by using xp_sendmail or the stored procedure i provided the link for in answer to your previous post or you...

Try having a look at the following thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=105655

there's a sample procedure there that i posted to send mail using collaboration data objects, make sure you scroll down to...

We had this problem.

It is either because an SID for that group or user already exists within the syslogins table of the master database or your DNS servers are not...

Susan you're problem seems to be that you need group the output obtained from the union. This is not exactly an elegant solution but should work. All have done is...

Unfortunatley I've already tried re-patching the client tools it didn't help.

Arvind

I had the same queries when i started using this method and have never yet got an incorrect number of rows whether it has been a clustered or non-clustered index...

You don't need to use count(*) to achieve this the number of rows in a table is stored in sysindexes.

e.g

SELECT rows

FROM DBName..sysindexes

...

You can use the maintenance planner in EM to rebuild your indexes on weekly basis or whatever is required.

Remember rebuilding the indexes will lock them preventing access to the so...

You should just be able to use CAST e.g.

INSERT INTO TABLE (NEW_FIELD)

SELECT NEW_DATE = CAST(OLD_DATE AS SMALLDATETIME(3))

FROM TABLE

If you need more complicated logic then just use the CASE statement ...