Search results for query: *

I have to bulk insert some data into a few EXT tables and would like to know how the dex_row_id is incremented and if this can be updated while in the insert process? Task is pretty straight forward and I'm not sure there is much more to it then that but my GP knowledge is fresh so if you need...

I'm in the process of setting up on all the instances in a new location notifications for jobs and other tasks. Currently the SQL Server machines to not have smtp services running on them so I am trying to avoid installing smtp in order to use CDOSYS or CDONTS. The work around was to use one...

I optimized a query that was seriously killing the prformance of a load job and in this optimization created an index on one of our tables. Not sure if the details beyond that are needed but if they ar please ask. Anyhow, after doing this we're getting an error back from the DB2 instance as...

Hi all, I have a update statement I just can't seem to sort out. I'm a sql server native so this has been a struggle. I did some searching for similar statements and the syntax for doing it but haven't found much. Basically I have to update records based on duplicate values found. The...

Extremely good article by one of our very own and probably most talented mrdenny Optimize disk configuration in SQL Server Read it and don't forget to thank him for his contributions to our community :-) ____________ signature below ______________ You are a amateur developer until you realize...

Kind of verification question. I'm working on something this morning to export attachments to some shares. I'm using the AllDocuments property off a mail file to iterate the mail documents and check for embedded objects etc. Something I see happening is the inbox is not being included in the...

I'm in the process of writing up a landscape for a new SQL environment. I just wanted to throw a few things at all of you to make sure I'm on a level playing field here. I'm fighting with the operations manager on SQL versions which is starting to get rediculous also. My argument is Standard...

Might be old news but I was looking for a quick way to extract all the reports to rdl files from a reporting services instance and came across RSScripter Worth a look if you ever need to do this. Readme RSScripter ____________ signature below ______________ The worst mistake you'll ever make...

The short story is I'm attempting to access a remote resource from within an ASP.NET app via UNC path by the GetFiles() method. After much reading I see that even knowing I have full impersonation and the use of windows integrated authentication set the worker process plays a big role in this...

Does anyone know what the required (minimum) permissions Netbackup needs to backup a sql server database? Essentially is should not have more than backupoperator roles but this is not working and only a sysadmin role on the account works which isn't acceptable and a major security problem...

I have a SQL Server 2005 SP1 box that I'm using Netbackup to backup the master,model,msdb and user databases. I'm getting failures on netbackup when I do not have the netbackup domain account in the sysadmin role. Under no circumstances do I want this account in the sysadmin role so my...

Does anyone know if there is a concurrent limit of users that can have the sapsetup running from the SAP Installation Server? Version being upgraded is 6.20 to 6.40 ____________ signature below ______________ The worst mistake you'll ever make is to do something simply the way you know how...

I would like to point out two remarkable achievements that recently occurred in the T-SQL Forum. We are lucky to have such MVP's around us as the entire list to the right of this posting and to have those MVP’s share the wealth of knowledge with us. I wanted to point out that gmmastros and...

Hi all, I've manage with reading and checking out examples on the net to get the output I want from my first crack at this. Please reference thread707-1284165 for an explanation on my situation and the process I need. In short sense that thread is a bit confusing I need to update an xls from...

Quick questions. I've looked around and still am in the process but I'm not finding the answer easily so I thought I would post the question also. I need to update an Excel file from the contents of another Excel file. Both Excel files contain only one worksheet but the names of the sheets...

Is there a way to unexpire media we had a library go down over a week ago and just now got it running and the media server back up. Problem is we need to perform a restore on media that has expired but not been used sense then. We're on 5.0MP6 Thanks General FAQ faq333-2924 5 steps to...

Good morning Veritas Forum I'm in the process of reading the Admin guide and thought I would post a thread also to see if anyone around has some info for me. Here is what I have The expected process after completed .NET Application is run on a scheduled task once a year to archive a...

Questions have come up recently about database usage and also general questions on how to or what to use. Along with those questions I've seen a few poorly thought up processes using the wrong data area for the wrong needs. Due to all of this I've posted a FAQ that should help get everyone get...

Has anyone gone deep into SQL Server 2K Reporting Services? I thinking of looking into it due to a task that in my eyes can be completed easily with something as old as ASP3 but want to introduce some new (but old to the world) technology to my team. The task is quite simple in a active...

I have a email that goes out when a backup job fails using the backup_exit_notify command and it seems to have stopped working as it originally was. when I call the bperror -S %5 >> %OUTF% the description no longer is written to the text file. Has anyone found the same problem of late or does...