Hi, Are there web hosts out there that offer sql server with a trusted connection? Every provider I see doesn't mention offering a trusted connection. Forgive me if this is the wrong fourm and if it is could someone please direct me to the right place to ask this question. Thanks! Rangin...more >>

want to get back the source code of the stored procedure which is created with 'with encryption' option. sys.sql_modules/sys.all_sql_modules/syscomments dosent show it even after logging in DAC. All I see is null in the text column. and no luck with the trace as well. Thanks, GA ...more >>

Hi, I have inherited a problem with code pages. When the server has a different code page to the client the unrecognised characters are being passed across as a question mark - ?. I believe this is because SQL Server tries to translate it to the code page it is using but can't find a match....more >>

Hello, A databased application has more than 5000 tables. More than 50 concurrent users from various locations are supposed to query the database at any given time. What should we follow in order to achieve the ideal operational condition? Should we keep one central server with single datab...more >>

Is it possible to create a stored proc that allows the passing of a variable number of parameters? I'm creating a stored proc to populate a Suggested PO form. It may require filtering on one or more vendor IDs (string data). I've looked through BOL but nothing is jumping out at me. I also was loo...more >>

I'm trying to connect to a SQL Server at work from my virtual PC> The virtual PC is not logged in under my domain account as it is not part of the domain. I need to be able to connect to the domain account using Windows Authentication. For other services (sourcesafe, printing, shares etc) I...more >>

Hi, I know it is possible to to obtain values from the modified record using 'from inserted' and 'from updated'. What I would like to know to if it is possible to obtain both a before update and after update value for comparison? Specifically, I have table called Crates, and each Crates re...more >>

I'd like to setup a trigger to send an email, but can't use SQLMail because I don't control the password to the account that is running the MSSQLSERVER service. Is there any other way to have SQL send an email when an insert is made to a particular table? Plus IT doesn't like the idea of Out...more >>

Hello, Is there a way to replace all occurences of multiple characters in string? For instance, I need to eliminate all occurences of "-", "/", "\". Right now I'm doing it like this: REPLACE(REPLACE(REPLACE(String, '-', ''), '/', ''), '\', ''). It's awkward, especially if I have to replac...more >>

Hi Everyone, I'm rather inexpereinced with SQL. I have a question to ask you guys. I have a column in SQL Server 2000 database in table 'a'. It's populated with some values. Someone would like to move the data from that column to a new database, 'b'. After that is accomlished, they would ...more >>

I have 2 instances of SQL. On is on my laptop and the other on my server. I have a field that automatically updates the user filed when the record has changed. It uses whatever user is logged into the computer at the tiome that the record was created or changed. The problem is that I created a n...more >>

Hi, I'm wondering what the standard practise is for dealing with the following very common scenario: You have users who can use your application and they are identified by email address. Sometimes you want to delete one of these users. You want to keep some reference to them in the DB for a...more >>

I have a small sql server 2000 database that has never been backed up. The drive where the main database file resides failed on the server but the drive where the transaction logs is still good. Can I recover the database from just the transaction logs? And can you point me to some docume...more >>

Has anyone seen this error message? Autogrow of file 'tempdev' in database 'tempdb' cancelled or timed out after 2140 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size. I am getting these in my error log. It's a clustered environment with AWE enabled in it. SQL Serve...more >>

I detached a DB, now when I am trying to reattch it I cannot find the data or the log file. I know I have not deleted anything from the drives the only thing I am not sure exactly where they were located prior to the dettach. This is on a test box but we still need to restore the db. Is there a...more >>

I am in the process of moving our old SQLServer to a new I64 server. Everything has been tested and working fine except there is a scheduled FTP job task that didn't go through. I am hoping if I need to make changes to accomodate the new I64 platform. In the new SQL Server, the job tas...more >>

in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last ...more >>

Hi, everyone. I trying to connect a SQL Server 2005 to an Access 2003 frontend. Now in the past I have not had any trouble, but today seems to be a different day. Every time I go to try and open a dao.database object I get the error "Run-Time error '3000'': Reserved error(-1038); there is ...more >>

In Enterprise manager I could connect to a sql server I was administering via the Internet simply by setting the computername to the Ip address of the server. How can I connect to a sql server like that accross the internet using the new sql 2005 management studio. Thanks for any elp. Bob ...more >>

If we have a SQL 2005 server with one dual core processor and we want to add a second dual core processor, can this be accomplished without re-installing SQL 2005? We are using the per CPU licensing model. Thanks ...more >>

hi i have two "Person" tables one in server SQL01 and the other in server SQL02 i will integrate these two tables in a single "Person" table in other server SQL03 then, i think all the "inner/left joins" to "Person" table won't work because "Person" table was moved how can i "join" to...more >>

Hi, Can I use a query governor option in a connection string? if yes, what is the property name I have to add in the connection string? I don't want to setup this at the server level but only in specific connection strings used by my users when then do ad-hoc reporting using Report Builde...more >>

Hi, we have a strange behaviour in SQL2005 Standard on W2003S. The default language is us_english, but sometime during the night the language changes to german and all error messages etc. pop up in german. Has someone seen anything similar? ...more >>

Hello, I am building a web form that will be used to gather information for marketing plans. The form will have 15 questions. Each question can have large blocks of text. The issue is that the user will go to the web to enter and update their information, so all the questions need to be ...more >>

Hi, I have a Question regarding Backing Up transaction log. Very Basic I take full backup of my database every day in the night. During the Business hours i take backup of the Transaction log every 1 hour. I have selected the option Overwrite Media. Will this option erase the transact...more >>

I am working on SQL Server 2000. I am trying to create a Case Statement where I do something like the following: I want to set up the case statement to check if a value falls within a specific range then sum the unit amount as the type of data it represents. SELECT COMPANY, FISCAL_YEAR, ...more >>

Hi I'm no doubt missing something obvious as usual... I've run Performance Monitor for a day and I've got a .blg log file produced. How do I use it? How do I get information such as maximum and average counter values over the day? I've Googled all over but can't get an answer. Cheers ...more >>

Hi all, I am a beginner to T-SQL and have now come up against a problem... I was getting an error message saying that my queries couldn't be carried out as the tranction log file had reached its file limit. Following this i found out that the file was now 44GB in size and had completed fille...more >>

I moved user DBs to a new SQL 2000sp4 server running win2003r2, also moved the MSDB, not the Master, then I used DTS to transfer user logins to the new SQL box. Now I have problems changing some login permissions. When I try to add a database to a login I get this error > "error 15081: membe...more >>

Hi, Have a query that runs okay in SQL 2000 but when I try to run the same query in 2005 it hans the server. any suggestions thx...more >>

What is the tempdb for? Our production Goldmine Database is 8GB. I noticed that our tempdb is 800MB and growing. (only like 600MB last week) There was also an error event ID 17052 from source MSSQLSERVER last week, but it has since stopped happening. It talked about errors backing up the ...more >>

Hi everyone, I have a problem, and the problem is this. I have a development server with an ISP with Windows Server 2003 and SQL 2005, this server is not part of our companies domain. I have multiple laptops, of which are apart of our companies domain. I would like to connect to SQL 200...more >>

I inherited an application (or two) that run on SQL Server 6.5, which I haven't used in years, and am having a problem. I get the error: ------------------------------------------------------------------------ Can't allocate space for object 'Syslogs' in database 'master' because the 'logsegm...more >>

Our dev database was not built correctly for phone #'s so all of the sample data or test data (not sure if it is legit) has them in the form of XXX-YYY-ZZZZ. Is there a query that can remove the dashes from those values and turn it into XXXYYYZZZZ? Thanks. ...more >>

hi, My problem is I am creating a new database. I need to all the tables and procedures from one databse to another database in sql server 2000, both in same server. Kalaivanan. ...more >>

I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters on performance monitor. does anybody have the same situation? Thanks...more >>

Hi, I have one server with OS Windows 2003 Enterprise edition, SQL Server 2000 Enterprise Edition and 512 MB RAM. The database size is 2.5 GB. Currently i am faceing performance issue. I want to know that this issue is due to low RAM or due to any other factor. Should i increase the RAM...more >>

Hello! I'm trying to upgrade an application using SQLXML 3.0 to 4.0. The application is based upon different templates (xml-files) which are hooked up to a virtual directory. The problem is that I cannot find any description of how to migrate these to 4.0. It seems that templates as files a...more >>

Hi, When I used SQL Server Management Studio to open several tables (SQL 2005), some records are not listed in the order - for example, listed by orderid, customerid, or so on. Is there a way that I can have them listed in order? Many thanks in advance. ...more >>

My sql port needs to be exposed to the net to allow remote connection to enter data into db using xml and stored procedures. App connects using a lock down user name that can only run a stored procedure. What alse can i do to make this as secure as possible ? - im using IP filtering on the...more >>

We are using SQL Server 2000 and are going to install the first SQL Server 2005. We would like to know whether it is possible to use Management Studio to manage all existing SQL 2000 Servers ? Thanks ...more >>

select dateadd(millisecond,-1,convert(datetime,'20080101 0: 0: 0',112)) why isn't it 20061231 23:59:59.999 ? -- SoftMedia Technology Co., Ltd. Website: http://www.softmedia.hk Tel: (852)2743 4228 * TryEasy Accounting/POS/Trading/ERP solutions...more >>