Search results for query: *

I have to import a bunch of spreadsheets (example below) that all have the same format into a SQL 2005 table. Some records have only one SEQ_NUM while others may have as many as twelve; it might be possible to end up with more than that. Record SeqNum Text RanData1 RanData2...

I'm using SQL Server 2005 and am trying to create an SSRS report that uses an SSIS package as a data source. So far, I've: 1. Edited the RSReportDesigner.config file. 2. Created a fairly simple SSIS package that uses a DataReader Destination. 3. Created a shared data source of Type: SSIS and an...

I have Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) running on a Windows 2003 Enterprise SP2 cluster of 2 nodes. I noticed that the SQL backups work fine when the cluster is on Node A but fail when on Node B (I can run backups manually without issue). I found an error ("Unable to read...

Here is an example of a result set with four calls (each call starts at Step 1): DateTime Svr Step 20100131085346688 VS01 Step 1 20100131085346703 VS01 Step 20 20100131085348188 VS01 Step 30 20100131085348281 VS01 Step 40 20100131085355282 VS01 Step 52...

Our system spans multiple servers and the logs are stored in a central database. Each application flows through a decision tree, with each 'box' being a step. One of the things I am responsible for is tracking errors. The errors can happen at any step in the decision flow, which then defaults...

RiverGuy, gmmastros, Thanks so much for the swift replies. This was exactly what I needed. Alex

I am not a DBA. I am just a grunt who knows some SQL. I babysit a proprietary IVR system that pretty much does what it is supposed to do, and everyone was happy until... The statistics database was built to track when a call hits various menus in call path script (events). The main...

I have a Visio document that I put quite a bit of time into. I planned it as well as possible before starting and added all the custom properties I needed--in order--from the get go. New manager, new requirements, and now I need to add new custom properties. I want them to sort...

I recently called the folks at Computer Associates to find out if they support writing to DVR media with Arcserve 11.1. They said that they do no support it but that it might work. I was wondering if any of you had tried it and, if so, what degree of success did you have. Thanks, JP

George, Thank you so much! This is almost exactly what I was looking for, with just enough nit-picking left for me to figure out how this works in the process. -Alex

I've got a question which is probably pretty basic. I have a database which has 35-36 day's worth of data. I am trying to format the output of a query so that it can easily be cut and pasted into a spreadsheet. I'm guessing that I probably need a cube or some such, but cannot get it to work...

vschumpy, thank you so much! Happy holidays!

I've been to http://supportconnectw.ca.com looking for Service Pack 5 for ArcServe2000. I have had dismal luck searching the sight. Does anyone know *exactly* where to look? A link would be most helpful. Thanks, Alex

At my last job, we supported a SQL database with a VB front-end. Portions of the code were riddled with "undocumented features" which had the potential to lock up the entire database, bringing production to a screeching halt. Using sp_who2, we could see figure out which SPID was the ultimate...

I inherited supporting a system with Arcserve 2000 on a W2K Server Advanced system. As far as I can tell, we are at SP2. Upgrading to the current version of Arcserve is not an option which I have, but I might be able to swing a different service pack past the platform acceptance folks if I can...