Hi, how can i create a new table from a select statement? i use select into, but my select query has case columns and query analyzer says that i did not specified a column for them. how do i do it? thanks in advance for your help ...more >>

I have created a batch file in Visual Studio .NET. It's like this: osql -S %1 -d %2 -U %3 -P %4 -b -i "dbo.Sun_Report.prc" Sun_Report.prc is a UNICODE file. When I run the batch it throws this error 1> 432> Msg 170, Level 15, State 1, Server PLWIL-ARCHIBUS, Procedure Sun_Report, Line 18...more >>

I am working on creating a function to modify my Calendar Date Format. SQL have several Date formats but not the one I need. The date format I need is 01-AUG-2005 but I can not seem to get it fully working. The date format I am converting from is 08/01/2005 and converting to 01-AUG-2005. ...more >>

How do I found what jobs have previously been scheduled for a database. I see the Tools - Job Scheduling option, but now an option that shows me what has been created and scheduled. Thanks....more >>

I have a txt file with about 400,000 rows of data. I need to import this data into SQL 2000. Is BCP the way to go? Is there any special format the file should be in. Is there a sort of BCP for Dummies documentation to help me? Paul...more >>

Hi, how can i prevent the access to my tables in sql 2000. ...more >>

Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it ...more >>

Hello kindly tell me that is there any way to update a table in a user defined function I want to execute a Update Command in the Function . Plz help me as soon as possible Thanks ...more >>

I'm having trouble trying to get a Select Statement working, my current statement is attached below. I have two tables: Table one (tblProducts) is product description & Table two (tblExtraProd) is a list of ingredients for each product. I need to be able to select and ingredient that needs t...more >>

There are two servers. One local second linked but SQL Server. In local server linked server is registered. From enterprise manager we can access tables on this linked servers. Also from Query Analyzer we can access table of given database on linked server. Local login 'sa' is mapped for this l...more >>

Hi all, I want my application's Installer to automatically install the SQL Connectivity on machine in which the Connectivity does not exist. For this i require a Stand-Alone installer (to be called from my Installer if connectivity is not found). Do you know if there exists a Stand-Alone C...more >>

Anything like automated restore ? For example, I have scheduled the full backup on Sunday night, incremental backup on weekday 8 pm, and transaction log backup every 4 hours everyday. What kinds of restore should I set up ? ...more >>

Please I need with some urgency... Information about sp_helprotect (function, syntax, examples) Thanks in advance for your soon answer..! Patrick...more >>

Hi, we recently had to restore the msdb database on a different instance. Now I can't change the SQL jobs. I receive an error 14274 because SQL Server regards the SQL job as originated from an MSX server. What can I do (except manually make modifications to msdb) and what should I do in the...more >>

This is probably simple from someone's perspective but I would hate to find out that this is a bad idea the hard way. I am hoping to set up a second SQL server to tinker with ,using the database from a backup of the production server, but I don't want to take any chances with fouling u...more >>

Hello all, I want to know where I can retrieve my backup schedule so I can chenge the schedule. Here's what I did: - in Enterprise Mgr, rightclick the database, select backup database from the all tasks list - click the add button, enter file path - check the schedule box, click the ell...more >>

From Enterprise Manager I get [SQL-DMO] CreateFile error....... Whenever I try to Generate SQL Script!!! Why?? Evan Camilleri ...more >>

When trying to install sp3 on an SQLserver2000 the installation program just tells me that there is no SQLserver installed on the computer and then just quits. I know for a fact that there is an instance of the server installed so that's not the problem. Is this a known issue and if so, how do I ...more >>

How do I substitute a variable in select clause and from clause in select statement. SQLServer 7.0 ex. Select Variblename from Variablename should expand to select col1 from table1...more >>

February 15th, 2pm Pacific Time http://www.microsoft.com/technet/community/chats/chatroom.aspx Join members of the SQL Server development team as we discuss what's coming up in SQL Server 2000 Service Pack 4. See http://www.microsoft.com/technet/community/chats/default.mspx for more infor...more >>

Is it possible to use 2 tables in the same report with different dataset, but able to pass one field as parameter from one table to the other one? For example I have one table that has the field ITEM_ID and SALE. I have another table that has the field TOTAL_COST. I want to use the ITEM_ID ...more >>

I would like to Run a SQL Server 2000 Stored Procedure in Nightly basis (Every Night) to updates few records based on Criteria On windows 2000 server. Please forward me the steps and commands to be follow, to schedual a SQL Server Procedure through Scheduled Task in windows. Thanks in Advance,...more >>