Search results for query: *

I’m having problems reading the CellBackColor of a flexgrid in certain situations. If I’m using the click event on the grid, I am able to read the color ex. If MSFlexGrid1.CellBackColor = vbRed Then ‘this will return true if the cell clicked is red However when I try to reference by a...

SQL Server 2000 SP3 & Windows 2003 Standard Edition I have read many posts regarding this problem, including the MS KB article 295086, most seem to deal with W2000, and we are currently running W2003. I’ve confirmed that DTC services are running on the 2003 machine, and our SQL Server Name and...

My apologies if this is repeated, tried posting it earlier, but I never saw it. On our XP Pro clients, on boot up we run a batch job to map network drives, and then we register some Active X exe’s. (ex. C:\Windows>\\Jupiter\Pgmexe\DeLogin /Regserver). This routine works fine for the first user...

I have a maintenance plan that backups all the databases on the server to disk every night. This was working fine until this past week when I started having problems. When I view the job history for the plan, it shows if failed (00:00:00) run duration with the following error message:” Executed...

Let me preface this post by saying I have very little experience with networks, but working for a very small company, the responsibility has been ‘dropped’ on my lap. I’ve tried my best here to document the problem, any advice would be greatly appreciated. I have a SQL backup to disk that runs...

One of our master databases seems to be populated with various user tables, plus the regular system tables. Everything seems to be working OK, but I’m not a 100% confident of it. How could this possible happened, but more important, how do I go about fixing the problem? Many thanks,

I had a DB with about 21 GB’s of data. First I deleted a lot of temporary tables cluttering up the DB and then I performed the shrink database job from Enterprise Manager, allowing 10% free space after shrinking. After the job completed, my data file still is close to 21 GB’s, but my backup to...

On an Insert trigger, what must I do to insure that the Insert completes, even though my code to update tables on a linked server may fail. Would the after trigger be applicable here? Thanks, Jim

Is it possible for SQL Server to change system settings on it own? We have had a couple of strange occurrences where settings have been changed, once how memory is allocated (dynamic vs fixed) and the other one was maximum connections was switched to 1 and of course SQL basically brought itself...

We have one (of four) SQL Server on out network that has been causing problems the last couple of days. Some fairly intensive procedures from VB seem to grinding SQL to its knees, we are getting timeouts, connection problems (automation errors), and low memory messages. We have restarted the...

Received this error when executing a store procedure that triggers an Insert trigger. Is there an easy solution to this problem? Thanks in advance. Jim Server: Msg 7395, Level 16, State 2, Procedure tgInsPubCap, Line 33 Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A...

We have 3 servers with SQL installed. From our VB app, we run a procedure that will select ~ 1000 records, do some processing and then updates. This routine runs off the master server, one the master it runs fine, when it run against one of the others servers, it hangs(holds on to locks). This...

I would like to create an SQL script that will create triggers on 25 different tables(is it possible?)within a database, the trigger will always be the same except for of course the table name. I tried creating a script using a Cursor (it will be use very infrequently!) but get an error at the...

We had 4 servers (A,B,C,&D, A being the master) each with SQL Server installed with multiple databases, all connected via Linked Servers. We just tried bringing a 5th server on-line, after having some problems with out apps on our new server (E), we remembered that this server had not been...

I've taken the code below from this site, it is from a store procedure example. Is there any reason why this would not also work for an INSERT Trigger? I'm trying but I keep getting the message that I must declasre the variable first. declare @my_var VARCHAR(35) select @my_var=CUST_NAME_S from...

I'm tryiing to set up a DTS package, I would like to use a stored procedure rather than type in query to gather the information I want to export. I can't seem to find anyway to do is, is it allowed, and if so, how would you go about doing it. Thanks in advance, Jim

How can I add an existing DataEnvironment and Data Report from one project to another, VB6 makes it easy for an existing Form or Class, but I see no way to do it with Designers. I tried creating a new DE and Report in my new project with the same name as the ones I wanted copy, closed the...

When I use the package and deployment wizard to package my VB6 application, I get as far as choosing a folder to place it in, after that the program stops responding. Background, new machine with XP professional, has an academic version of .net installed. Have never packaged an application on...

I'm creating a Data Bound Report in VB6 (against Access 2000 DB), using a DataReport and DataEnvironment, with an SQL Statement as the source of data. Question is how can I pass a value/parameter (ex Invoice No.) to the where clause in the SQL statement to make the report more dynamic.