Microsoft SQL Server Forum

I will be deploying an application on an AIX server. Is there an SQL Server client software that I need to install on the AIX box to enable it to communicate with SQL Server?

I have a Visual Basic 6 application that uses MDB or SQL Server databases. I was wondering if it was possible via Automation or ADO or some method, where I could programmicatlly upsize an MDB database to SQL Server. I can run the upsizing wizard from within Access to do the upsizing, and the database converts fine.

I am having problems with long timeouts when connecting to or executing commands in SQL Server 2000 SP3. I am writing an application that will be used on laptops within an environment that is wireless. The application is written in VB.NET using the SQL Server managed provider. I have set the "Connect Timeout" parameter on the connection...

hello, thank you for hint but: i want to read this data from file My file.txt file is like it: " 1234567890 abcdefghij " etc 1 column | second column | third column

Hello, I have problem: My *.txt file is like it: " 12345612345678123 abcdefabcdefghabc " etc.

My ISP recently had me reset my TCP/IP stack. After that, Norton Personal Firewall prompted me twice that SQL Server was trying to access the Internet. Both times I responded to allow it to and to always use that action. Now I am not able to use SQL Server with NPF enabled. If I disable NPF, SQL Server works fine. I am using the desktop...

Hi all, I have two tables tbl_A and tbl_B. Table Definitions: tbl_A (field_1, field_2, field_3) tbl_B (field_1, field_2) I would like to populate tbl_B when a record is inserted into tbl_A. Note that tbl_A.field_1 = tbl_B.field_1 and tbl_A.field_2 = tbl_B.field_2 . How do I write a trigger on tbl_A to get the corresponding record

Hi I have a deadlock situation and I am trying to debug my Trace Log. How do I find out what is the cause ? I can see from the trace I have an exclusive lock on a RID, but how can I find out what/where 'RID: 7:1:431830:13 ' is ? Regards

What is the best method of creating schema creation scripts that can be stored into a version control system. The process of using em to generate a script is not an appealing option. I am still learning the MS Sql sys tables and have not found a useful list of all the codes & types to join the tables etc. mike

Getting 0 padded values in the columns. Hi All, I have a requirement to convert a integer to string and display it in Sql server with fixed length say 3 chars. (in c, we wud use %03d in printf) If the number is small say, 9 then it has to be displayed as 009, 56 -> 056, 897-> 897, 6786 -> xxx

Greetings, We are trying to set up a set of "Leading Practices" for our developers, as well as ourselves, and hope some gentle reader can recommend some documentation in favor of what appears to be the right position to take. We do not allow third party applications to run on our SQL Servers. We want to include DTS Packages under the...

Hello all, Lets say I have the current date and I would like to get the date two weeks in advance. How would I do this in T-sql? The T-SQL should take into account if the month changes. For example, if todays date is 1/17/2003 the advanced date would be 2/17/2003. Thanks, Billy

Hi All, In continuation to previous posting, I have one more query : A column with String containing hex values say, CA02B. I have to access the value in a int variable, any hints on how we should proceed on this? Thanks & Regards, Chandra Mohan

In relation to my last post, I have a question for the SQL-gurus. I need to update 70k records, and mark all those updated in a special column for further processing by another system. So, if the record was Key1, foo, foo, "" it needs to become

Hi all, I know that it is possible to encrypt Stored Procedures using 'with encyption'.But my problem is that when there are so many decripting methods available how far will the encyption be secure. Is there any other method to encrypt the stored procedures that are residing on the customer sites. We do not want the customers to meddle...

I have above server and I cannot install MS.SQL server on it. I have WIN-xp professional. I tried sql 2000 personal version as well as sql 2000 professional version, it says "cannot install on this operating system " I would appreciate if someone please help me. Thanks.

I have a table with first_name, last_name, salary, other_columns. I can produce sql to print the max salary but only with the salary column. How do I get first_name and last_name etc to show with the max(salary). Thanks

Hello, Has anyone a small tool or somekind of document which could help me to convert Oracle SQL scripts to SQL Server? Scripts are not very Oracle specified. Thanks, Below is a Script that I would e.g convert to MS SQLServer:

Okay, Let's say I have a table containing photos and they are also categorized according to the event that the photos were taken from. How can I select a recordset of one random photo from each category?

In SQL how can a cursor be opened to iterate the result set returned from a stored proc -Rahul Sood rsood22@yahoo.com

Hi all Using SQL Server 2000 SP3 on WIn2K Pro with SP2. When I do this SELECT PATINDEX('%%', 'ABC]DEF') GO

How do I do this when my instalation cd is an old veriosn with no SP´s? Win 2003 requires MS SQL 2000 SP3 sp what do I do??? Regards Anders

ISTR QA running in 7.0 would return print statements and messages as the query ran (well, after a "GO" statement anyway). In 2000 it doesn't return any messages until after the entire query batch has completed. In wanting to keep an eye on progress on long batches, how can I make 2000 work more like 7.0 in this respect?

here is a search tool SP I wrote. How many times have you wanted to search all your Stored procs or views (in a database) for a keyword but couldn't!? Well now you can! THis can makes life a lot easier for developers. Would you email me and let me know which part of the world my code is running in?

We have a SQLSERVER database that is replicated to many users. We are currently in an expansion phase where we need to make changes to the server database. Each time we rollout a new release, we are deleting the local replicating database and recreating. Is there any way to automatically transfer the changes from the server to existing...