Search results for query: *

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...

It should work if you use the following to identify your backup file \\servername\sharename\file.BAK GL Rosko

Or you could use this Insert Into Table2 Select DISTINCT t1a.ColA, t1a.ColB, t2.ColC From Table1 t1a, table1 t2 Where Not Exists (select * from Table2 t1b where t1b.ColA = t1a.ColA and t1b.ColB = t1a.ColB) and t1a.ColA = t2.ColA and t1a.ColB = t2.ColB Rosko

If you want to restore the master database you have to start it up in single mode from the command prompt. sqlservr.exe -c -m then you can restore it from within the query analyzer window if you have a valid backup. If you had a crash and it can't be recovered you should use the rebuild master...

If you receive an error like that in combination with quotes always change your outer double quotes into single quotes. And you should use your DBNAME.OBJECTOWNER.OBJECTNAME identifier. Otherwise you could have some problems too. That should do the trick Hope this helps GL Rosko

bperry 's statement should work. Did you by chance forget to replace Col1... with your own column names? Rosko