Microsoft SQL Server

• Microsoft SQL Server Questions

• • " Error 65535: General Error".

    Hi AllI am having this error when i try to start Enterprise Manager, " Error65535: General Error".Th...

    By mittykom

  • Avoiding From Cursor

    Hey,I Have 600 Views Which i Need To Insert To One Table,The Method I Chose Is To Prepare The ListOf...

    By chaic

  • Avoid Repetition of primary tabless record

    hi all,can you tell me how to avoid repetition of main records when one main(Primary table) record h...

    By aamiranga

  • Yukon Beta Program

    Craig,SQL Server 2005 Beta 2 Developer Edition is available fordownload for MSDN Universal, Enterpri...

    By paulibison

  • AWE Sql Server 2000 Error

    I have a box running -quad 3.0ghz xeon processors16gb ramSQL Server 2000 Enterprise Edition SP4 (pat...

    By punga33_hotmail_com

• • AWE - SQL Server 2000 - Memory usage

    Hi all!We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.Microsoft gave the adv...

    By florisvanhaaster, 3 Comments

  • AWE Memory

    Hello We have 2 servers in a cluster environment with 12 GB each. We install SQL server 2000 in them...

    By anonymous, 2 Comments

  • Avoiding NULLS how ?

    Two examples where we use NULL fields, how to avoid them ?For a datetime field, date's which ar...

    By benbrugman, 2 Comments

  • AWE Memory

    I am finding conflicting opinions on how to monitor memory bottlenecks on AWE enabled systems. Can a...

    By anonymous, 3 Comments

  • Availability after an instance crash.

    Up to now I have no experience with an instance failure ofa large database.If you have a database sa...

    By benbrugman, 3 Comments

• Microsoft SQL Server: is the Category's subject.It's has 382,149 questions,this is No.19,108 pages.
• Multiple rows combined into onerow and onecolumn separated by a special character
• Hi All : CREATE TABLE TABLEA(Person Varchar(20), Country Varchar(20), Subject Varchar(20), Type Char(1)) INSERT INTO TABLEA VALUES ('Einstein', 'Germany', 'Physics', 'P') INSERT INTO TABLEA VALUES ('Kant', 'Germany', 'Philosophy�...
• anonymous, Thurs, 11 Mar 2010 04:50:00 GMT, 1,530 bytes, 3 Answer
• Deploying SSRS in SQL Express Edition with Advanced Services
• Hello, I am having a difficult time with a complicated task. I have developed numerous SSRS reports for my application and want to deploy these reports with my application. The application uses SQL Express Edition with Advanced Services. I have written an installer to automate this process, but ...
• timstspry, Thurs, 11 Mar 2010 04:42:00 GMT, 1,642 bytes, 2 Answer
• "Action Canceled" message while running long reports on SSRS2005
• We have implemenyted Forms Authentication on Report Server 2005 and depoloyed it in the DMZ . Ref: http://msdn2.microsoft.com/en-us/library/ms160724.aspx Anytime I try running long reports (a report with years worth of data doing some intermediate calculations), I get an "Action Canceled" page i...
• anonymous, Thurs, 11 Mar 2010 04:36:00 GMT, 1,139 bytes
• behind the 8 ball !
• THIS IS ABSOLUTELY LEGAL!!!!!You are requesting a legitimate service and you are paying for it!!Like most of us I was a little skeptical and little worried about the legalaspects of it all. So I checked it out with theU.S. Post Office (1-800-238-5355)and they confirmed that it is indeed legal!!M...
• poolsharks, Thurs, 11 Mar 2010 04:36:00 GMT, 6,159 bytes
• Yukon beta date (?)
• Hi I have an MSDN subscription and have gotten the ability to play with Whidbey and its great. However, I am interested in doing\testing Yukon with .net and BI. When is the release date for the public beta or some version where I can download it if I have MSDN Sub thanks in advance...
• anonymous, Thurs, 11 Mar 2010 04:32:00 GMT, 298 bytes, 1 Answer
• "colspan" functionality in a table?
• I want to display a label and some column totals in the footer of a table. The label text is wider than any column in my table. Is there some way to tell a table column that I want it to span more than one column? I do not want the footer column to expand because it causes the whole table column...
• ddill65, Thurs, 11 Mar 2010 04:29:00 GMT, 756 bytes, 1 Answer
• "An error occurred during printing (0x80004005)" SQL RS 2000
• We've had SQL Reporting Services, with SP2 installed on our production server for eight months now. All of a sudden this morning the Print Icon gives the following error when you try to print. "An error occurred during printing (0x80004005)" This error happens on every report, from any mach...
• anonymous, Thurs, 11 Mar 2010 04:26:00 GMT, 714 bytes
• AWE and Perfmon Counters
• We have enabled AWE on our SQL 2000/Win 2003 Ent servers and are now havingproblems seeing true memory utilization by SQL Server. For example, TaskManager shows SQL only using 174,712 k when it has been configured to 13gb.Not to mention perfmon memory object is not reporting accurately either.Wi...
• batman, Thurs, 11 Mar 2010 03:32:00 GMT, 479 bytes, 1 Answer
• AWE and SQL Server 2000 SP4 (899761)
• Thanks Mike.Paul"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in messagenews:euYYVbRdFHA.1384@TK2MSFTNGP09.phx.gbl...> Hi> For a list, you can find it here.> http://www.aspfaq.com/show.asp?id=2160> For some reason, it has not been updated to the latest fixes yet.> Chee...
• paulcahill, Thurs, 11 Mar 2010 02:39:00 GMT, 899 bytes
• "Add user or Group" button greyed out in "Lock Pages in Memory" wi
• I am trying to set up a service account in the "Lock Pages in Memory" window<br>but the "Add User or Group" button is greyed out. I am logged on as an<br>Administrator. Does anyone know why this is?<br><br>The OS is 2003 R2 Enterprise Edition and we are using SQL Server 2005<br>Standard Edition.<br>...
• neilw, Thurs, 11 Mar 2010 00:09:00 GMT, 300 bytes
• Avoiding deadlock
• I have a stored procedure spUpdateClient, which takes as params a number of properties of a client application that wants to register its existence with the database. The sp just needs to add a new row or update an existing row with this data. I tried to accomplish this with code somethign like ...
• natehekman, Wed, 10 Mar 2010 20:10:00 GMT, 2,736 bytes, 8 Answer
• AVs, Fatal Exceptions 17066, 17052, etc., etc.
• I'm having a hard time with Sql Server 2000 at the moment after over a year of smooth operation. I hope someone here can help as I'm completely lost.Sql Server 2000 SP2 - 8.00.534 Win2k About 1400 databases.After a while, sometimes 24 hours sometimes 2 hours sql server terminates with...
• podge, Mon, 08 Mar 2010 11:39:00 GMT, 1,237 bytes, 13 Answer
• AWE questions
• We are looking to take advantage of AWE in a single instance of SQL Server 2000 Enterprise running on a Windows 2000 Advanced Server. The cluster will have 8GB of physical memory. I would like Sql Server to use 7GB and leave 1 GB for the O/S. If I understand the documentation correctly we need t...
• anonymous, Mon, 08 Mar 2010 10:58:00 GMT, 874 bytes, 2 Answer
• "30 Second Query Timeouts"
• When running a query using views from a DB2 link serverwithin SQL 2000 server I get a query time out error.Looking on technet the time out duration is not aconfigurable option within SQL server 2000, is thiscorrect'When I run the same query using Microsoft Access ODBCconnectivity to DB2 the...
• simon_brayford, Mon, 08 Mar 2010 10:54:00 GMT, 771 bytes, 1 Answer
• '' = 'ss' - are the equal?
• Hi,I've set up an NVARCHAR table column having a UNIQUE constraint. This =UNIQUE constraint is supposed to keep double entries from being entered =into that column. So far so good...In my new project I'm quite baffled about the fact that SQL Server 2000 =seems to believe that '=DF...
• axeldahmen, Mon, 08 Mar 2010 10:13:00 GMT, 793 bytes
• AWE in SQL Cluster
• I have a two node cluster with SQL Server 2005 that I am having difficultygetting AWE to work. I have granted the "lock pages in memory" right to thedomain account that the SQL Server service is running under on both nodesand run the following commands to setup the AWE memory.sp_configure 'a...
• cgal, Mon, 08 Mar 2010 09:35:00 GMT, 765 bytes, 5 Answer
• AWE / Maximum Server Memory
• We have a clustered environment with each node having 8GB memory, Win2k3Enterprise Edition SP2, and SQL2k Enterprise Edition SP4.I have read a few articles on AWE and the following link provided me with alot of information, but I still have a few questions:http://www.sql-server-performance.com/a...
• larry_herbinaux, Mon, 08 Mar 2010 09:24:00 GMT, 1,708 bytes, 2 Answer
• error al crear plan de mantenimiento
• Hola,Estoy creando un plan de mantenimiento para una base de datos SQL Server2005. Tengo una instalacion en 64 bits. El plan de mantenimiento incluye lobasico, reconstruir indices, chequear integridad, actualizar estadisticas,etc.Lo estoy tratando de hacer con el wizard, pero al llegar al final...
• edmundoj_davila, Mon, 08 Mar 2010 09:24:00 GMT, 1,523 bytes, 7 Answer
• "Closed" database
• Hello,I was wondering if it is possible to create a database that can beaccessed only using a username password combination, even when beingaccessed from the Enterprise Manager.It seems EM can always access all data, however when I distribute thedatabase, I don't want some tables to be view...
• poostwoud_gmail_com, Mon, 08 Mar 2010 09:16:00 GMT, 421 bytes, 5 Answer
• "browser does not support scripts...."
• I have a local user account that I created for testing RS. When i right click IE executable and do "run as" the local user account, I get the following error message when trying to generate a report. (I have given the local user account access to the report.)"Your browser does not support script...
• pacevedo, Mon, 08 Mar 2010 09:08:00 GMT, 2,329 bytes
• «««191001910119102191031910419105191061910719108