Is this possible. To explain myself, here is my situation. I created an Excel Spreadsheet that uses an ODBC link to a SQL database. In order for anyone to use this file on their PC, that same ODBC link must be setup. Is their some code I can use within a Select Statement that will allow me...more >>

How do I get them out ? Thanks....more >>

I've known for some time that if I go to a "Tables" view in a database, click on a table or tables, and copy, I can then paste into Query Analyzer or Notepad, and it will paste a SQL definition of the table(s) I copied. Or so I thought... Today, after highlighting and copying, I accidentally...more >>

Have an MSDE named instance which works just fine. Just installed another instance of the same and can only connect to it using OSQL locally, nothing across the network. I made sure to use all the gotcha flags during install to enable network access, etc: setup.exe DISABLENETWORKPROTOCOLS=0 ...more >>

Hi, I have installed SQL Server 2000 on a Windows Server 2003 machine with an instance name of "TestDB". But I cannot connect to this instance from another machines. It doen't even show up in the Enterprise Manager's "Register SQL Server" window. But if I use the default instance, it wor...more >>

For some reason I had to change server name. I also created new registration in Enterprise Manager. When I try to retreive data, it still looking for my old server name. Where else should I change the server name . ? Thanks ...more >>

I have a colunms which contain all the numeric data I want to change the format in the runtime like 145263 that should be like 145,263. Is there any way to do through sql query? Thanks ...more >>

I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do I need to start? For example. I would like to have a cell in Excel that gives me the sum of Sales Orders in my SQL Database. I would also like for this to be able to change according to a date field in excel that c...more >>

Am trying to connect to a db created in SQL Server 2005 Express by using the native client drivers but get an error message that connection fails due to server not allowing remote connections. Am trying this by using Powerdesigner 11. I can connect using the Management Studio Express client an...more >>

Hello all, I got a application which is developed using VB6.0 as front end and MS-Access as backend. Now i would like to change the database from MS-Access to MS-SQLserver. How do I change the databse from MS-Access to MS-SQLServer? Regards Jack...more >>

Hello, Thanks in advance for any help/comments... I am trying to deploy the rsprintclient in a locked down environment. The end users do not have admin privs and thus cannot download and install the ActiveX print client. I have tried to copy the contents of the RSClientPrint.cab to the...more >>

Hi All: What is the MDAC application that allows you to create server aliases if you don't have Client Tools installed? ...more >>

Hi, I have installed in one computer a named instance of SQL Server 2005 Developer Edition. In that computer there is also a SQL Server 2000 instance, which is the default. For SQL Server 2005 I have allowed local and remote connections through TCP/IP. The SQL Browser service is active too....more >>

I have been using connection pooling in a midle tier application with a very good result. But I've always wondered what it means - when several articles mention that the provider will divide the pool into subpools so to speak based on transaction context among other things. What exactly does ...more >>

I want to findout the users and its role in specific database like that user has db_owner rights, I want one query that I can execute in the Query Analyzer and findout the role. Thanks ...more >>

Is there any way I can findout the password of any database users ? I forgot the password of that user and I don't wanna change becauase that password is using in so many applications, I would appreciate if any one can let me know. Thanks ...more >>

Hello all, Can anyone here help me to solve the following problem? I have developed an application with vb6.0 as front end and ms sqlserver as back end. I have already made .exe and now i want to use my application over the network. I tried making a shortcut on the client pc from the main pc...more >>

Dear Professionals, One quick question, what is the quickest way to copy the all the database from one server to another including database logins and jobs and every thing.. Thanks ...more >>

Is there anyone who have an idea when Access ADP (2003) would support SQLExp 2005? Is there any download to make them work together? Pls help, many thanks....more >>

I have an access database that is currently at the 2GB limit that I would like to convert to SQL. I used DTS to load the database into SQL and created an .adp project in Access to get at it. The problem occurs when I try and open the .adp project it kills whatever PC I am on because it loads t...more >>

I have two servers, the sql agent service on both servers are running under a domain account - rrg-sqlagent which is an administrator on both servers. The initialization of the database works but 15 minutes later when the the log shipping starts to occur i recieve the following errors. does an...more >>

Hello! I have a client app that will connect to SQL Server 2005/Analysis Services. I have an installation program that is supposed to deploy the app. I guess I need to include SQL 2005 drivers in the setup package.But I can't find a stand-alone, redistributable version of them. Where are ...more >>

I am getting this error when loggin in to our application connecting only to a specific server. We were experiencing some "db connection or not enabled errors" previously and to solve the problem I installed the SQL Client Network Ulitities and setup the TCP/IP protocol with the remote SQL se...more >>

I've got SQL server 2005 enterprise, and my server is gonna be a WinServer2003... and one of my clients it's gonna be a WinXP Professional.... ¿what do i need to install in the client ? because the installation, gives you to choose .Server components, tools, samples, ..... ....more >>

We are currently using VB to create order numbers. Each user requests an order number as and when required. The problem is that the next in the sequence seems to be allocated on the odd occasion to more than one user. This being due to the requests coming at almost the same time but not as yet...more >>

This is a rather weird one if anyone can help. I create a new diagram on my machine through Enterprise Manager ver 8 then go to another machine modify the diagram with EM ver 8 and save it. When I re-open the diagram on my machine there are no tables in it. Anyone know of any issues relati...more >>

What is the SQL equivalent to a REPLACE ALL command in VFP? I found this in the help section: SELECT REPLACE('abcdefghicde','cde','xxx') GO Is this the full syntax and where would I use this command, I tried in the EM but it doesn't seem to work. ...more >>

Given a single table: tblAddresses,=20 with records Counted at 800,000 and very clean, and with these column definitions, inAddress_PSK INTEGER IDENTITY PK (1,1) (No Nulls, No Doops, PK) vchAddressLineA VARCHAR(30) (Not Null Doops OK) vchAddressLineB VARCHAR(20) (Nulls OK,...more >>