Hi all, What does SQL Server 2000 Standard do if the number of CALs is exceeded? E.G. does it refuse the login an indicate that no more logins are allowed, or what? A client's system occassionally bogs down. It is most likely due to a poorly designed front end app, but I was wondering if ex...more >>

Hello please help me, Here inm having a dout wether can we sum the data in the column in the dbGrid. Say if we are having a column name sal can we total all the sal and bring it in to the last clumn inthe same column for example Name Sal ...more >>

Hi , We are using the a 4 CPU SQL Server 2000 Enterprise edition for our application , We want to migrate to SQL2005 with the compatibility level downgraded to SQL2000. If we go for the SQL2005 Standard edition is there any problem? We are not using the Failover clustering in our server. ...more >>

I tried to standalize the sql server query so that I don't have problems with the date... but it is giving me error when i pass query like this: tb_Activity.DateAdded>'2006-08-15' however, it's accepting queries like these tb_Activity.DateAdded>'2006-15-08' Now, i thought the first n...more >>

I am a New SQL Server DBA. Today i was asked to create a user(only read-only access). So I went to Enterprise Manager than Security-->Login(Create New Login). After I created the account, I noticed the user can see and do everything n database. Even though i just gave him a public permission. ...more >>

Dear experts, Again, sorry to bother you again with such a seemingly dumb question, but I'm having some really mysterious results here. ie. Create procedure the_test As Begin Select CustomerID >From dbo.customers -----------------------------*/ Server: Msg 170, Level 15, Sta...more >>

Which SQL 2000 sp4 do you install on SQL 2000 client machines? x86 32 bit servers thx...more >>

Which SP4 for SQL 2000 do you install for SQL client on x86 servers, 32 bit? thx...more >>

I'm in the process of installing and configuring alerts using the subject tool on our sql server 2000 instances but I've noticed a problem with the tool and single-quotes. It seems any alert which returns a single-quoted value in the message text generates incorrect code when trying to ex...more >>

waitresource ------------------------------ TAB: 12:600441263 [] I had blocking issue. I query sysproceses table and it shows me process are waiting for "waitresource=TAB: 12:600441263 []" TAB table 12 -- it is DB id...it is not problem to find dbname...sysdatabases 600441263 - table ID...more >>

Dear Experts, Ok, I hate to ask such a seemingly dumb question, but I've already spent far too much time on this. More that I would care to admit. In Sql server, how do I simply change a character into a number?????? In Oracle, it is: select to_number(20.55) from dual TO_NUMBER(20...more >>

How do you add a boolean column or the best alternative to a SQL Express database? ...more >>

How can I get similar results from a query like this > SELECT au_lname, state FROM authors WHERE state IN ('CA', 'IN', 'MD') Except to replace ('CA', 'IN', 'MD') With a field that will have a similar format?? The Field is Misc it's contents are (100, 101, 102) and so on. I need to display ...more >>

I am using the last updated date field to give me the dates I want, but I want to narrow that search to give me only the greatest date per project id. Here is my query: SELECT POReqHdr.ProjectID, POReqHdr.User5, POReqHdr.PONbr, POReqHdr.CuryTotalExtCost, POReqHdr.Descr, POReqHdr.CuryPre...more >>

All, I have been saving large BLOBs into a Sql Express Database and notice that each time I save many records (6000) the size of "sqlservr.exe" grows each time but does not decrease in size even when I shut down the application that performs the storage. I assume this because "sqlservr.e...more >>

I'm trying to determine if this error (http://support.microsoft.com/kb/811274/en-us) has been fixed in SQL2000 SP4 or the SP4 cumulative hotfix. I can't find it listed on MSDN, but it's rather difficult to scroll through the dozens of numbers looking for one specific fix. Note to Microsoft: Why ...more >>

Is there an easy way to find out who is currently accessing a particular database? We use SQL authentication. Thanks. ...more >>

Hello, I have an application that is running on W2K3 with 2005 SQL server and that has a link to another SQL server (2000). When using this application when I go to update something that would be updated on the linked server, I receive the following error: The partner transaction manager has ...more >>

The query builder in enterprise Manager(Database,Tables,Table,Open Table, query) is giving me a timeout ODBC error on a long query. Is there a way to configure the query builder? I can execute the query in Query analyzer fine....more >>

How can I find out and change the Default sort option in the Server for SQL 2K? Thanks in advance. Perayu ...more >>

I upgraded from SQL 7 to SQL 2005. Everything is running smoothly, but I just noticed that one of the databases is still in SQL 7 compatibility mode. I need to change it to 2005 compatibility mode in order for the backup maintenance to occur. If I change the DB from 7 to 2005 comp mode, will I...more >>

We are having massive problems with speed issues between a FoxPro application and a SQL server database. Are there any known problems in this area ? Si...more >>

I need start and end date of previous month, such as StartDate=07/01/2006 and EndDate=07/31/2006 for currentdate 08/156/2006 How can I do this? ...more >>

I'm having the following problem with the backup I have running on our SQL Server. I have it scheduled to run once a week and when I check the event viewer I see the following: SQL Server Scheduled Job 'msdb backup' (0x1DA8D66C8D076D4D973B1AF97C122CA7) - Status: Failed - Invoked on: 8/13/200...more >>

Books online recommends creating the FTS catalog in a new filegroup I have created a FileGroup called FTS (not readonly and not default) However the following syntax fails. CREATE FULLTEXT CATALOG Z_Search_Freetext ON FILEGROUP 'FTS' IN PATH 'C:\Program Files\Microsoft SQL Serve...more >>

Install sql express on Windows server 2003 standard sbs. When the Sql ServerSerive Manager starts the Server pull down is on server and there is two options "server" and server\sqlexpress" and no services available. When I change it to "server\sqlexpress" I am then able to starts the service....more >>

Hi Our server has suddenly stopped logging job execution to sysjobhistory. The jobs actually run - I tested by running a backup job and the backup is successfully created. However, no entry is made in sysjobhistory and additionally no notification email is sent. This is not an issue with t...more >>

The installation of SQL Server 2005 (Express) has an option for default instance or named instance (SQLExpress as default) What are the advantages of setting up named instance and default instance? Thanks for answering... -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe...more >>

What is the way(s) to backup a database from a Server and restore it to another? Thanks for replying... -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1 ...more >>

Hi, I was copying a lot of rows using SELECT INTO and noticed that the tempdb was used extensively (at least it was growing while the copying was being performed). This also happened during an INSERT INTO select... Can someone explain for what tempdb is used in these cases? TIA,...more >>

I'm trying to execute a stored procedure in Sql Server 2005 Management Studio. I right-click, choose Execute and enter the parameters in the Window, but the DateTime parameters aren't handled corrcetly. I don't get same problem running same procedure in Visual Studio. I've tried several ...more >>