Recent content by Rosko

Thanks SQLBill, That's one way to go, but still not enough, I have to have something that collects CPU usage as well without generating to much overhead. Got any ideas? Thanks Rosko

Hi, Does anyone collect data from your SQL server and generate monthly reports on CPU usage, db growth and so on... What do you use for a tool? Or did you generate reports yourself and how did you go about that? How much performance degradation does continually polling generate? THX in...

Another question, is it possible to determine the instancename(server\instance) where the package is saved without having to write a query? Rosko

First of all? I want to keep everything on SQL server. I have a server(4 processors, 300 Gb, 4Gb Ram) with 3 instances of SQL server running. and this for the purpose of developpement, acceptation, production) On each instance the same databases. I created a few DTS packages on the...

You could use DTS to copy your table. Its an easy click and play (or click and pray) way GL Rosko

Ok But give me the line from yor master..sysservers table Maybe this can provide me with some info Rosko

Is your remote server name by any change beginning with a number? Show me the line in the sysservers table for this particular linked server, perhaps this can shed a light. Rosko

Check the database option CONCAT_NULL_YIELDS_NULL and set it to off. Maybe this can help GL Rosko

Perhaps you should watch out for case-sensitivity. If that does'nt solve it let us know if they are both SQL servers. Rosko

I would create an insert trigger for your case in which I would check the inserted.F1 field for the value you are looking for and do the necessary steps from within your trigger. Gl Rosko

Business Objects is a good tool for reporting in which the users can build there own reports without any knowledge of SQL. My previous firm uses it and it works quite well Rosko PS: This is not commercially intended

I think you have have got your identifier mixed up. Your identifier should be built like this server.database.owner_name.object_name I think your DB2 should be in second place as I gather that is the database name. Good Luck, Let us know Rosko

One of the possibilities is UPDATE YOURTABLE SET subtotal = (SELECT sum(T1.amount) FROM YOURTABLE T1 WHERE T1.day <= YOURTABLE1.day) This should do it GoodLuck Rosko

Oops, didn't see your never mind

I think the problem is a little higher up. I think you should use SELECT @intRecCount = (SELECT COUNT(*) FROM dbo.CRC WHERE DateTime >= @dtTodayAM and DateTime <= @dtTodayPM) instead of SELECT @intRecCount = COUNT(*) FROM dbo.CRC WHERE DateTime >= @dtTodayAM and DateTime <= @dtTodayPM...