Search results for query: *

thanks all. Very Helpful

Hi all, ok I have a sql 2000 server that has experienced some memory shortage issues. I was hoping to get some info via Enterprise Manager | sql server logs...but the size is 5.5 megs and EM just hangs. Where\how can I open the error log?

OK I am setting up a linked server through Enterprise Manager. I am on a SQL 2000 server and trying to LINK to a SQL 2000 Analysis Server. So I name it, choose the right provider, configure some provider options, give it a datasource server name and lastly a catalog which I figure equates to...

SO an update was taking much longer than expected. The sql was not wrapped in a transaction. I killed it expecting it to just stop, and whatever was updated remain. Instead it is rolling back. Can I kill this rollback,

thanks all, for some reason i was making it more complicated then it needed to be.

OK I have 2 identical tables. table1 col_ID colA colB table2 col_ID colA colB How can I update table1.colA, table1.colB from table2, using col_ID as a join?

Thanks, I figured as much. Since I happen to be experiencing a slow crash :) I thought as a matter of preparation(to go ahead and deactivate(online) the key now....but it seems it is just best to call if I have a problem on activation. BTW - I was just reading that only a m-board or case...

Before I reinstall XP Pro, do I need to go online and deactivate the key? Once I reinstall I am going to need windows updates, and I don't want it to tell me this is a 2nd instance or anything like that. How does this work?

thanks all. I will search processes via google but also armed with the knowledge that nothing really critical is listed in startup I will lean more towards disabling unknown items. In regards to McAfee(maybe all Virus suites). First I am going to stick with it for now as I only recently paid...

Hi All, I plan on addressing some long over due cleanup on my xp pc tonight. Basically it has become bloated a bit slow, maybe even some virus deletion. Basically my plan is this. 1. Run a full virus scan 2. Any virus defintions found look up and perform cleanup steps 3. Reconfigure my Mcafee...

Thanks. I just copied over RDS and RDL files and added them to a new solution. Actually when you try to view the copied datasets it will tell you what data sources it was looking for. The Build\Deploy went well and the 2nd instance of this report is now working from an alternate location...

OK so I did just copy the RDL file to the new server. I created a new project, and added an existing RDL. Unfortunately the RDL was just one of many in the source project, and also there is many datasources. This RDL I am trying to copy has 3 datasets....I can't seem to ascertain what data...

Hi, I am totally new to reporting services. I would like to copy a report from one server to another. Both are SQL 2005 servers. I found the RDL file for the report on the source server, do I just need to copy that file over or is there more to it than that

thanks, I am all set

I got a db in ssuspect mode that I would like to detach\attach. I get the following error when trying to detach. --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) --------------------------- Error 947: Error while closing database 'test_db' cleanly...

OK I found it, never mind, it was undeer Meta Data packages

I am looking at one of those darned Agent jobs that have a step of DTSRun /~Z0x180001C1D150E8FA3C8541A9C2030287D03D9D175D94B3CE4D88A2810A4F7446DC3B6C5B996B4C63767EB6B4E670199ADB452DBB70AD4DD48F3F95F48908F541186BAA2E4820E8535F5CE3FFB28B4B227C793C6FBB2581F29C4A5EB45FEFD72F06FAFDFB335B935F543A2B...

thanks for pointing me in the right direction. The key combination screen in MS Mouse gets confused, when I created the suggested shortcut and assigned an key combo, then while inputting it in MS Mouse, the run line comes up and the MS Mouse disapears. It has been doing that with other handy...

So I have a 5 button mouse and I use the run line a lot. Somehow I had one of the buttons assigned to bring up the run line. But now I have a new PC and I forgot how to configure the mouse to RUN. I know WIN key + R, works...but the Windows key is not accepted to include as a key combination...

Hi All, I just got a new PC, with SQL 2000 Client tools. One difference from my new and old PC is that from within DTS designer, datapump tasks; I can not see the full name of objects I am importing\exporting. With my old PC, the drop down list window width seems to expand to facilitate the...