Microsoft SQL Server Forum

Hi, I have copied a table structure with 13 rows from one db to other db after executing .. sp_dboption nowdb,'select * into/bcp',true .. select * into newtab from d1.dbo.oldtab The table is copied but the primary key is not unlike the oldtab has the pk.

Hello, Does anyone know of a way to loop thru a SQL table using code in a stored procedure? I need to go thru each record in a small table and build a string using values from the fields associated with a part number, and I can't find any way to process each record individually. The string needs to be initialized with the data associated...

I've added two more articles to my web site. Both are about error handling in SQL Server. I also cover ADO to some extent. The articles are "Error Handling in SQL Server - a Background", http://www.algonet.se/~sommar/error-handling-I.html and "Implementing Error Handling with Stored Procedures",...

Hello, I have a SQL server being the recipient of a message. The message comes in via TCP/IP and is sent to MSMQ. From there it is picked up by a COM+ object which puts the message into SQL server. This is all down via MSMQ triggers. The question I have is: How do I get the message to be REMOVED from the MSMQ queue after the message is...

Hi Team, Is anyone else out there struggling with SQL Server on XP? Specifically, is there anyone struggling with starting the Agent Service using the NT_AUTHORITY "security" role? I am having no end of grief. I started with a perfectly clean XP install. I performed an absolutely clean, default install, and the installation hung. It...

Hi all, I'd like to know if it's possible to sort twice in a same SQL query. I use SQL for retrieving Data into an Excel Spreadsheet. (Excel 2000 or XP) and to paste the queries results into an Excel spreadsheet. 1. I tried to sort by date and the only way was to use the serail number instead of the litteral name

Hi all, I want to create a stored procedure which will extract the "GroupName" from the record returned by "sp_helpuser". In order to do this I need to execute "sp_helpuser" which returns the entire record. I want to just extract the "GroupName" from the record and return it to my application. How do I go about this? Thanks in advance,

select *From titles (18 row(s) affected) Totally 18 records are there in Titles table. When I query select title,title_id From titles where title like 'T%' and title_id like 'M%'

Hi, is it possible to create an "INSERT INTO ..... "Select from stored procedure" Query? I want to create an temporary table. In this table I want to enter the data, which I can get from an stored procedure. But in the FROM-clause a stored procedure is not allowed?

I have a table that has numerical ID. I want a query that will get the 20 highest IDs. So in other words the query would return the last 20 results entered. What would even be better is if they were distinct entries by another column, but it still returned 20 results. Can you specify in SQL how many results you want?

Hi All, I need this urgently. Unknowingly i made something in my IIS. In my Javascript app i am using window.open to open child windows. All of a sudden when i try to open a child window the explorer is getting hanged. Do i need to make any setting in IIS to make my window.open function again. Help Please.

On a production database, there is a 2GB database, when I run sp_spaceused it indicates a very high quanity of unused space. The database has been shrunk & free space sent to the OS. Why is this value so high, what can I do to reclaim the space? database_name database_size unallocated space...

Dear all, I want to use C program to connect MS SQL server. I copied some sample file to install on my computer. When I run the program, an error occurred, which is about ntwdblib.dll not find in some paths. But when I check the paths again, they have ntwdblib.dll. When I run my C program in another computer, it works... so , I feel...

Dear All, I am performing a data import on the SQL server. Due to fact that I use the excel file as a source. Some of cells in excel are actually empty, they become NULL fields after importing into the SQL server. Actually I want these fields are empty string instead of NULL. Does SQL server has any approach to make these fields to be empty...

I have an ODBC link to DB2 Database. I can see the values of the DB2's tables in Access but not in SQL Server DTS. IN DTS, I connect the Source but when i want to see the values in the Data transformation task, i have this message : HResult of 0x90040e37 (-2147217865) returned. Erreur inattendue. Un résultat d'erreur a été renvoyé sans...

Hi All, I am facing a problem with a sql what i used in MS Access but its not returning the same result in MS Sql Server 2000. Here i am giving the sql: SELECT TOP 3 format( MY_DATE, "dddd mm, yyyy" ) FROM MY_TAB WHERE MY_ID=1 The above sql in ACCESS return me the date in below format in one column:

I have a java program that accesses an ms access database through odbc:jdbc. When deploying my program will the users need a full version of microsoft access to be able to use it? If not, what do they need and where can i get it from. Thanks

Any help would be appreciated. I am running a script that does the following in succession. 1-Drop existing database and create new database 2-Defines tables, stored procedures and functions in the database 3-Imports data using bulk insert 4-Analyzes data using stored procedures I would like to improve the performance of the analysis...

I have a table I'd like to copy so I can edit it and play around with the data. How do I create copy of a table in SQl Server? Thanks, Bill

Hi there, I want to search Japanese characters with Full Text search function. I created a table (tbSearch) for Full-text search on SQL 2000, English Win2k Server. The table contains 4 fields, which are ID -- int, primary key, identity; PageName -- nvarchar; Contents -- ntext; Keywords -- ntext. Defined a Full Text index and Full Text...

Hi I am getting this common error once or twice a day: Error: 9002, Severity: 17, State: 2 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. provided......

I've created a DTS package which creates a SQL server 2000 database table and then imports data from a .TXT file on the FTP server. My problem is this: I am allowed to select the source file using Network Neighborhood but the File Name that shows up in the Properties of my Connection (for the stored DTS package) is a reference to a C drive...

I've created a DTS package which creates a SQL server 2000 database table and then imports data from a .TXT file on the FTP server. My problem is this: I am allowed to select the source file using Network Neighborhood but the File Name that shows up in the Properties of my Connection (for the stored DTS package) is a reference to a C drive...

Hi, Is it possible to switch to another user's credentials after logging in? I seem to remember that there is a stored procedure for this, but I can't find details anywhere. I want to temporarily suspend my login's admin privileges and become an "ordinary" user, for testing purposes. Thanks, Peter

Is there a script anyone has that will automate the addition of an access database to the OBDC datasources in control panel. Thanks