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 >>

I have a user who created a new database which has since filled my storage disk. The backup type is set to simple and the Maintenance plan is set to backup the transaction log. However, the transaction bu job fails. The log is currently at 110 Gigagbyte and has completely filled the disk. ...more >>

Hi every one, I opened a DOS window. What I typed and what respose I got back are here below. C:\>osql -U sa Password: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. C:\> I do see the icon for the SQL Server Service Manager at the bottom of ...more >>

Hello, I have a very simple table that I need to setup a trigger for but I totally confused. The table config is as follows: Order Table orderid, salesClerkId, itemid, qty Inventory table itemid, desc, quantityonhand, re-order-level I need to setup a trigger on the order table that w...more >>

Supposedly, I can apply one or a series of Transaction backups to a database I just recovered from a backup file. Below, the command I found to run the transaction file I have. I need to know what “device” are they asking for? RESTORE LOG {databasename} FROM {device} WITH NORECOVER...more >>

1) How do I know the number of active users logged onto a particular Database schema on SQL server? I need to fetch this info anf display it on a web page. Pls provide the SQL query. 2) How do I know information about the Locks held on any particular database Object? Pls provide the SQL q...more >>

Hello, I have question about lisensing MS SQL servers. We are using software that uses MSDE as datastorage. Now we are developing software that makes possible to remote use that software through internet. Do we need bought some another version of sql server license to use our program thr...more >>

Hi, When i try to connect between ASP.Net developed in C# & SQL Server 2000 and establish a connection, i get the following error message "Unable to establish a trusted connection". Kindly advice,what are the stpes i need to take to resolve the problem. Thanks, Shyam...more >>

I have a pblm like following 1. i build one query dynamically(In Stored Procedure) through concatenation of variables 2. i have to execute that query & i want result back in the variable so i can use that variable. following is not the exact pblm but same like following declare @dt date...more >>

Hi to everybody This may sound a little bit strange but I need to create an incident report form to provides us with feedback from the users suffering a problem with an application, so because of mi lack of experience I don't know what to ask, I wonder if there is someone in the community w...more >>

I strongly beleive SQL server should be removed all rights of bneing called a RDBMS , When the basic Control statements like , Commit and Rollback does not work. I recommend that all the versions of the product should be completely scratched and band from using. If at all Microsoft membe...more >>

Hi, I have four queries that I have o run separately every and each time I need them. I feel there is a way of making these four queries became one, but this is high above my knowledge in SQL. As you can see in the queries below, the only difference between them are the 'origem' value (0100...more >>

Before moving data from Access to SQL Server, I had some update queries that I ran to import some 3rd party data from other Access databases. I was able to run the updates using a JOIN to the 3rd party data as linked Access tables from within my main Access database. Now all of the data is in S...more >>

Is it possible to change the timeout on a view run from Enterprise Manager? ...more >>

Hi, Is it possible to restrict sp_MSforeachtable only for specific tables in a database partial code --------------------------------- exec sp_MSforeachtable 'select ''?'', count(*) from ?' --------------------------------- thank you Regards Roman...more >>

Hi, I am backing up a DB from a server using Enterprise Manager. I just Backup the DB onto a file, copy that file over the network to my local machine and put that file in a temp folder on my local machine. When I try to restore the DB, I have a problem as it wants to restore the DB on the sa...more >>

I just recently installed MSSQL Developer edition on my Win-XP(SP2) machine. I had a prior Enterprise version of which I had started to build some other database for my own personal use. The databases tht I had under the evaluation Enterprise copy were physically stored on another drive on my ...more >>

Is this the correct newsgroup for MSDE basic questions?? ...more >>