I've created a database with SQL Server and a cube using that database with Analysis Services, but I could not find anything like the Cube Browser available in Analysis Services for client computers to use. I don't want more functionality than that which Cube Browser provides (although sortin...more >>

help : has anyone else had this problem. Connection to SQL Server Database Using IP Address Is Unusually Slow...more >>

I have a vbs script that connects to a database and runs a stored procedure where a linked server is also used in the sp. I get this error when trouble shooting on the line that tries to execute my stored procedure: Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver]...more >>

---not working--- create table mynewschedule from myoldschedule neither does insert mynewschedule select * from myoldschedule even though something like that was listed this week news:e$SuKdeYFHA.2508@TK2MSFTNGP15.phx.gbl I would like to extract some data from a table. Then let th...more >>

Hi What is the feature comparison of sql server 2005 full and the express product? If an application is developed on one, will it run on the other? Can we say that express is for clients who have previously gone for ms access? Thanks Regards ...more >>

How can I avoid this? I have the following calculations in a view: Data017_all.MTD_StkOrdAmt / Data017_all.MTD_TotOrdAmt * 100 AS MTD_OSO, Data017_all.YTD_StkOrdAmt / Data017_all.YTD_TotOrdAmt * 100 AS YTD_OSO, ....if the second number (the _TotOrdAmt) is 0, I get the divide by zero err...more >>

Does any body know if there is a way of scripting table with the contents? ...more >>

Hi there: We're in the middle of getting rid of small and meaningless databases but I need to move some of them from SQL Server to Access. Considering that I'm a newbie, wich is the better way to do this.? How I can move all the information from our SQL Server to Access..? Any help will be ...more >>

Hi I have a database running on MS SQL server 7, it is split into 2 files on drive c: and drive d: I run regular maintenace plans on the database. After carrying out transaction log backups, the transaction log has about 20mb in used space and 700mb in free space. Is it possible to shrin...more >>

I am on a home network, Linksys router... all my computers are set up using peer-to-peer (workgroup) connections... However, I have one computer (dual-boot Linux & Windows 2k3 server evaluation edition) that has sql server's evaluation edition loaded on it... I can see the win 2k3 server from ...more >>

Please help me :) ...more >>

Where could I find out what version of SQL Server were released in what years? I'm doing some research and need to know what versions were released when. TIA, Peter...more >>

I'm writing a .Net v 1.1 application that connects to a SQL Server 2000 Database using a SqlConnection object. Everything works fine as long as we are in the same network as the server, but once we connect from a client on a seperate network the connection fails. We're not really sure what i...more >>

What is the best practice for moving databases and data from one server to another on the same network? And how feasible is it to do this remotely?...more >>

What is the best way to monitor the database file growth? I need to setup an alert to email or page me when the datafile gets close to full. I see in the alerts you can create a SQL Server performance condition - SQL Server: Databases - Datafile size (KB) - Alert if counter rises above and t...more >>

Hello, I am trying to figure out the best way to design a many-to-many table relationship. For instance, I have a 'sites' table and a 'contacts' table. The sites table contains the name and address for each of our remote locations and the contacts table contains the name and phone number for t...more >>

Hi, I've got about 5 SQL servers running seperately, with seperate databases. What I need to do is pull certain data from each of these databases into a new SQL server database that I will create. What would be the best approach to go for ? Thanks! ...more >>

Hi Group, My company is about to develop its first SQL Server 2000 application (we have been using a Caché database for more than 25 years). Our typical application is installed on 20 - 100 sites. When one of our customers gets an updated version of an application, we need to ensure the...more >>

Hello, Is there a simple way to e/d a field in SQL table? Thanks, Matt ...more >>

Our SQL database show that they haven't been modified or accessed in weeks . .. . and yet our users are working with applications that access these databases on a daily basis. So why would the dates on the database files themselves show that it's been weeks since they've been used? -- Br...more >>

what are the advantages of actvie/active clusteing for SQL with Multiple database same instance. or is there any advantage. in other words will access to different database be distributed between the servers. -- troutman...more >>

I posted this on .programming, but got no response.. maybe because it's a newbie question: Hi, Do many people use the IDENTITY type for a column? The advantage is that every time you add a row, that identity column is automatically incremented, however, I have always wondered about the fo...more >>

Hi friends, Sorry for my not very good English. I am new in sql server. I am using sqlmoney to represent the price. First of all I am not sure is it good idea or I have to use decimal? And my second question is haw to cut the last 2 digits of sqlmoney (I mean for example 12345.1200 t...more >>

Hello, I linked an SQL Database table from a remote server over the internet, via ODBC. I can't make changes from Access. I get a write conflict message with the only options being to Copy to Clipboard or Drop Changes. The save option is disabled. I am able to create a new record from ...more >>

I am working on a C# application, using SQL Server. I can create a script to create the database, but I'm want to have the database created during the setup of my application - not running the script from Query Analyzer. It seems like there would be a simple way of running the DB script from...more >>

I've made "crosstab" queries in Access - it this doable in sql?? My table has: ID TestNumber Score Each user can have 1-3 records, one for each of the 3 tests. I need my output to look like this: ID Test1 Test2 Test3 --------------------------------- 1 score1 sc...more >>

I just imported a Access database that has a AutoNumber field. The field converted over to Int. Is there a AutoNumber type function that I can use? I don't see what I can use in my drop down for Data Type ...more >>

Do you need to enable awe option for memory over 4g for SQL on a Windows2003 server the same as windows 2000...more >>

I need a little help with this query. I am querying the value of field, but I need to add to the logic that if there is no record then the value = 1 This is the query as I have it: ------------- SELECT * FROM dbo.ParametersUsers WHERE UserId = 1713 and ParamName = 'showpopups' ---...more >>

My server in in NE and I am connected via a VPN in NV. I would like to schedule a back up or copy that would send that copy over to my local machine in NV each day. I really only have two tables, in that database, that I am concerned with backing up. tblAccounts, tblContacts. It appe...more >>

Each time I try to install Server 2000, Developer Edition, on my Pentium III system running Windows XP Pro, I receive the following message: "The system file is not suitable for running MS-DOS & Microsoft Windows applications. Choose Close to terminate the application." Then the installation p...more >>

Hi, all. What Datatype like memo field in MS Access? :) ...more >>

Hello, I'm making a view in SQL Server EM. In this view I want to generate a field which combines 3 other fields simply together. I have the fields: lngNumber (numeric), txtOpdrachtgever (string) and txtAfdeling (string) which I want to combine (with a space between each field). In Access rep...more >>

What is Reporting Services Books Online? I have seen reference to this in postings....more >>

I have used my enterprise manager to automatically backup SQL databases but am a little unclear on how to restore. I would like to do test restores to an alternate location so as not to interfere with daily operations. Any help or recommended reading would be appreciated. Thanks...more >>

Hi friends, Sorry for my not perfect English. I am new in sql, please help me with problem. I have a table preview and table products. When the user clicks button "submit" all data from current posting in preview have to be moved in table customers. I am using this SP CREATE PROC...more >>

Hello, I have a question regarding transactional replication. I have one publisher/distributor and a remote subscriber. I have a push subscription which works fine and runs once on the hour except for one thing - each time it runs, it creates all the database objects again, i.e. all tables ...more >>

Hi all, I have a "history" table in my SQL2000 DB, this table is the most busiest and bigest among the others, we also found that the "select Max(history_key) +1" statement is the highest "number of read" sql statement in our db. So I'm thinking, if I set the History_key field to auto inc...more >>

how to delete data using query analyzer?...more >>

Hello, I'm using SQL2000 and I have a table which has a field within it called "ImageFileName", what I would like to do is create a trigger to automatcially delete the disk resident image file that is contained within the "ImageFileName" field of the table upon the deletion of any of these...more >>

How do I import an XML file into a SQL table?...more >>

How can I make the default value of a column = a different column in the same table? ColumnA ColumnB ColumnC ColumnC Default Value = ColumnA thanks for your help! Doug Evans Server Systems Administrator University of Puget Sound ...more >>

Hello, I would like to have someone be able to monitor replication jobs without giving them full admin rights. Is there any way that someone can see and manage replication jobs without being added to the SysAdmin role? thanks ...more >>

hello, I have my database server environment on the same pc where i have my development environment because i am still in the testing mode, but when i want to switch to the production mode, i want to install my db server on a separate computer so that clients can use the application. The ques...more >>

hello, I have my database server environment on the same pc where i have my development environment because i am still in the testing mode, but when i want to switch to the production mode, i want to install my db server on a separate computer so that clients can use the application. The ques...more >>

Hello, which are the users technical access limitation when you are using the sql 2000 workgroup edition? thanks a lot for your reply...more >>

Hello I am unable to find a way to pass parameters to my Report. developed in Sql Server Reporting service 2000. Kindly tell me how to call a report with parameters. i am able to call a simple reports only . Thanks ASIF...more >>

Hi Everyone, Currently, as stated in Microsoft SQL Server 2000 Books online (64-bit), it stated that it only support Intel® Itanium™ and Itanium II processors with 64-bit CPU. I would like to seek advice if the current SQL 2000 64-bit SQL supports the new Intel Xeon MP processors code...more >>

If a .NET transaction gets rolled back and a SQL SP that, itself contains SQL transactions had already been invoked, will the SQL transaction get rolled back if the .NET transaction gets rolled back? If not, how would you handle this? Thanks, Scott ...more >>

I keep seeing tutorials on Query Analyzer's templates that show something like this for the Object Browser: http://www.windowsitpro.com/Files/09/21176/Figure_02.gif I.e., when you click on the "Templates" tab of the Object Browser, all the default .tql template files are nicely organized in ...more >>