I'd like to set up an ODBC DSN to a table in a linked SQL Server, via my local SQL Server. I'm having a few problems: 1. When I use Enterprise Manager to link the remote SQL Server, it doesn't allow me to select the database in the remote server. It only shows one database. 2. When I use ...more >>

Our MS SQL (SQL Server 2000) DBA has database privileges locked down pretty tightly. We end users/developers do not have administrator privileges for most databases. That arrangement has worked out OK for the most part. However, it's a bit aggravating that we can't even create our own databas...more >>

I need to dynamic select a column in which insert a vale based on a parameter value, I have this code, but it throws an incorrect syntax error. How do I dinamically select a column to insert based on a parameter? Create PROCEDURE dbo.UpdateDetalleOT ( @eotId int, ) insert into OT ( ...more >>

Hi, I have a few users (user1, user2...) I want give user1 remote acces possibility , and deny remote access users: user2 & su. May I also give acces ony one ip - How may I do it? Greetings...more >>

<<cross posted from microsoft.public.sqlserver.server>> Environment: Windows 2003 Standard Edition SP1, SQL 2005 EE RTM (both servers) I am getting the following messages when I run this query: select * from LINKEDSERVER.databasename.dbo.tablename OLE DB provider "SQLNCLI" for lin...more >>

I was trying to install Reporting Services on Windows Server 2003. but it seems to need Visual Studio .Net 2003 installed. I just can't download .Net 2003 anywhere.is it any different than Visual Studio .net? is there another way to install Reporting Services for SQL Server 2000. we canno...more >>

We made a poor decision a long time ago when designing our database structure. We used bigint data types as the identity keys for many of our base tables. For many reasons I would like to change these fields to int at the largest. The largest data in these fields is around 200,000. I know th...more >>

Hi all, I'd like to know what the best means available is to enable distributed queries from a SQL Server 2000, on tables in BOTH SQL Server 2000 and a remote DB2 server (the latter is not yet available for testing). So, I would be wanting to write queries or SP's like: select t1.field1, ...more >>

I haven't touched MSSS in a looong time When a SELECT returns say 3 rows what does the feedback say ? (eg Oracle/sqlplus says "3 rows selected") What if "no data found", what is the feedback ? thanks ...more >>

I have a table like this: Name, SSN Joe Smith, 1111 Tom Why, 2222 Larry Sam, 3333 Paul Tom, 4444 Steve bob, 1111 I want a query to pull off Joe Smith, 1111 Steve bob, 1111 because someone accidently put in two different names with the same SSN. There should only be one 1111 in the...more >>

Can someone help me parsing this ms-access PIVOT sql-statement to a ms-sql-server sql-statement? Many thanks in advance TRANSFORM Count(KlantenStops.id) AS AantalVanid SELECT KlantenStops.Uitvoerder, KlantenStops.Klant FROM KlantenStops GROUP BY KlantenStops.Uitvoerder, KlantenStops.Klant ...more >>

One of our clients is in need of following requirements . OM Designer:- Location: Mountainview,CA Duration: Long-term Startdate: ASAP No of positions: 6 Skills 8 years of experience Strong Functional Skills in Order Management and Distribution Modules. Atleast 3 Implementation ex...more >>

Hello, I'm using a shape query, but instead of using a simple clause "RELATE field1 to field2" (relates the parent to the child), i wan't to use 2 relates. somthing like "RELATE field1 to field2 AND field3 to field4". I want to receive in the children RS only the records who apply both cond...more >>

This seems like a very simple question but i have never been able to find an easy answer to it. I have a user table and i do a join with another table, we'll call the other table a results table. The results table has numerous rows with the userid foreign key. I want to make a query tha...more >>

Hi all Can anyone tell me where I can find any information on using HTML as a user frontend to a SQL 2000 db? Thanks in advance Driesen -- Message posted via http://www.sqlmonster.com...more >>

Hey Everyone, I am a stored procedures newbie, so I wanted to ask if it is possible to use them with PHP via an ODBC-ODBC bridge connected to a MS SQL server. I am simply use the commands from the php odbc library to connect and execute the SQL commands, I am trying to avoid building dynamic ...more >>

Hello, I'm not getting any response to this on the SQLDTS newsgroup, so I thought that I would try here: I just ran into this problem and I can't find any other mention of it through Google. I have a text file that is comma-delimited. It also uses double quotes as text identifiers. A new co...more >>

Hi, The following request select a constraint from TABLE_CONSTRAINT with the name specified in the where clause: select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where constraint_name = 'FK__51OtherParties__51Claims' It returns: http://graphicsxp.free.fr/constraint.JPG So I have TAB...more >>

Hi i want to create a table as follows : if exists (select * from dbo.sysobjects where id = object_id(N'[Indexes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [Indexes] GO Create table Indexes(indexname Varchar(100), index_Description Varchar(100), index_keys Varchar(100)) GO ...more >>

I need help...here is the problem. Last weekend, the servers in our datacenter where moved around. After this move, and maybe coincidental, 1 server is performing very poor. After running a trace with SQL Profiler, I saw the problem which was later confirmed with another tool for SQL server ...more >>

Hi all, I have almost 50 DTS and its was scheduled run daily at a specific time. Since last week all the jobs was failed. Error "The process could not be created for step 1 of job 0x43434...... (reason : The system cannot find the file specified). The step failed.". The jobs was run find befo...more >>

Hi all, My program is a central data processing application built in ASP. We have different companies that use different web pages on another web application (from different countries) to load some inventory data (merchandise - clothes). Here is my requirement: Load different types of dat...more >>

Hi, I wonder wether a software or a device (or script) allowing to migrate data from an existant database to a new database by using correspondant ODBC drivers existed. Thanks for your help. ...more >>

Hey guys, I'm trying to get the column names from a table to which I'm connected through OBDC. I don't want to use linked server. I get my data with Openrowset. I found the SQLDescribeCol and SQLColumns ODBC functions. Can anybody tell me how to use those functions in a SQL Server stored pro...more >>

I get this error: Msg 137, Level 15, State 2, Line 2 Must declare the scalar variable "@DBName". W/ this code: --Constants DECLARE @DBName varchar(20); SET @DBName = 'Base'; GO --Create & Use Database @DBName USE master GO if exists (select * from sysdatabases where n...more >>

Hi, Is het possible to find information about indexes in SQL Server 2000? Information like pad index, fill factor, index fields, SortinTempdb? Gr, Hennie ...more >>

Well I am the MS-SQL user I always face the problem in my application. After some time my application stop working goes in to the not responding stage. Then I have to KILL some session which are SPID > 51. After this my problem is getting resolved after this I can able to create new sessions. ...more >>

Hi, I have just started using MSSQL and the DOS environment at work. I have a lot of experience with Sybase and the UNIX environment, but this is a whole new ball of wax. I'd like to use osql from a batch file to log into the dataserver and run a fairly long list of SQL and then exit. ...more >>

I am relatively new to SQL server. I am tring to send some decimal values to the database using a stored procedure with parameters of type DECIMAL. Every time it inserts the values into the database the decimals are truncated. I saw on the MSDN library that you have to set the precision and scal...more >>

Hello everyone, am new to databases. Started of learning SQL on my own and using SQL Server 2k... any pointers from ya'll abt my approach... got familiar with some basic stuff abt SQL and SQL Server.. hope all of you would gimme good suggestions.. ...more >>

Hi, All: Please help. I use sql server as back end and Access 2003 as front end (everything is DAO). A table on SQL server has an identity column as the key. We have trouble on adding records to this table using the following SQL. strSQL = "INSERT INTO myTableOnSQLServer (A, B, C, D, E)...more >>

I have my SQL Server installation on drive c: and the databases on another drive. My c drive got corrupted and I am planning to restore it from an old backup. This means drive c will not be up to date. Is there anything that SQL Server saves in the registry or in its home folder that changes f...more >>