Search results for query: *

Cheers, This is a followup: Microsoft replied to our case, and found in their analysis of the system and DB logs, that a third party open source encryption dll which we use to encrypt user' passwords was the cause. It caused a memory corruption which cause an SQL file curruption whch we resolved...

Thanks foryour help. I lloked at the links you rpovided earlier but none helped, because we have a different behavior. It affects many SPIDS in the system and not related to a particular query, though , only one online application -websphere/linux- is having broken connection pipes every now and...

Cheers all, We have an HP DL760/8 CPU with HyperThreading Enabled/8GB RAM and an HP EVA5000 SAN running win2003 /SQL Server2000 SP3. The main active DB size is 400 GB with many tables having more than 30 million rows. Suddenly we are experiencing error 3624 for no apparent reason. Any one has...

Cheers all, We have an HP DL760/8 CPU with HyperThreading Enabled/8GB RAM and an HP EVA5000 SAN running win2003 /SQL Server2000 SP3. The main active DB size is 400 GB with many tables having more than 30 million rows. Suddenly we are experiencing error 3624 for no apparent reason. Any one has...

I have a database LAN connected to 2 WAN networks and dedicated fiber link into a mainframe. The database LAN is made up of a Cisco 4000 layer2 switch with no VLANs and one subnet 10.0.6.x ... WAN 1 is extranet type and i control the router with subnets in the 172.x.x.x range. All routing is...

We have 2 pix firewalls one protecting the perimiter the other protecting the internal apps. The first is working fine, but the internal pix sops passing packets to the apps network after a while. The only way to keep it running is to pass some packets from the inside to the perimiter network...

Sorry for the typo .. i meant sp_addlinkedserver ... ________________________________________________________________________________ If you do not like change, get out of the IT business...

With .net and any DB2 on os390, i find that by installing the microsoft HIS2000 client and using the microsoft oledb driver for db2 work easily and efficiently. You need however to run a utility that ships with HIS2000 called something like "create odbc package" which creates some...

How do i change a datagrid two column styles to show a combobox bound to some db table and related to another combobox column in a parent/child relationship[in the same datagrdi], such that when the parent column changes the child column combobox changes too ... Urgently need a solution ...

Microsoft SQL Server runs on Windows platforms only. For IBM mainframes you can run Oracle/Os390/zOS [not recommended as DB2 is better suited], or ,Oracle, DB2 or MySQL on a Linux partition on a mainframe.... ________________________________________________________________________________ If...

Make sure the option "allow pull subscriptions" is enabled on the source publication server .... ________________________________________________________________________________ If you do not like change, get out of the IT business...

During importing data you should be presented with a wizard that enables you to re-map[called transformation] field names and data types. ________________________________________________________________________________ If you do not like change, get out of the IT business...

It sure sounds like a networking problem. It may be good to try all sorts of connectivity to the server, such as file sharing or terminal service. If you get intermittent problems then that should be an indication of a bad network connectivity...

Read on: http://search.microsoft.com/gomsuri.asp?n=4&c=rp_Results&siteid=us/dev&target=http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_5j8l.asp And http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_71d1.asp It should be ok to add the files...

Encapsulate all transactions within stored procedures, including both the BEGIN TRANSACTION and COMMIT TRANSACTION statements in the procedure. This provides two benefits that help to reduce blocking locks. First, it limits the client application and SQL Server to communications before and after...

It should be possible. Just use UNC format for the file names like \\servername\sharename\filename.XXX ... ________________________________________________________________________________ If you do not like change, get out of the IT business...

With Query Analyzer you get more chance to really learn the power of SQL Server. EM is very limited to some GUI type design environment. With EM you can not do everything you do in Quer Analyzer. More, if for instance you need to write a stored procedure or trigger in EM, you'd be presented with...

You can not do that ! Create a linked server to the target SQL database server. Search SQL Books Online for "sp_addlinkedserver". One that is done, use the following DDL according to your need: create table linkedservername.targetdatabasename.dbo.test( id int,name char(20)) ...

I concur with you Terry. I list below some URLs for nowayout that shed light on the subject and on the use of SQL Profiler .... http://www.sql-server-performance.com/sql_server_profiler_tips.asp http://www.sql-server-performance.com/application_design.asp...

I quote the link below. "I was able to duplicate the problem from the application, so my first step to finding out what caused the problem was to run a trace in Profiler. This easily identified the guilty query. I cut the slow-performing query from the trace window and pasted it into the...