My company currently has about 20-25 Ms Access Database that they want to replace the FE with .net and the BE on SQL. This will be done using Visual Studio 2005. Once the FE is converted to .net and the BE is SQL they all will be accessed through our intranet (sharepoint). I work in Ms A...more >>

I do not understand the sequence in which to add logins/users. A couple of things to note. I can not use vbscript - it has to be done using the sqldmo objects (or in a sql script). The sequence I use now is: 1- create login, set default db 2- add login to sql server 3- set db owner 4- cre...more >>

A system stored procedure got accidentally deleted, and all backups are since the stored procedure was deleted (wonderful!) Can the SQL for the stored procedure be extracted from another server and loaded as opposed to removing everything and then rebuilding the server? Thanks in advance! ...more >>

I have a very strange problem, it only happen to one SQL Server, other SQL Server seems to be fine I got the following error when trying to run a sp against one of the SQL Server: SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET ...more >>

Access 2002 SQL Server 2000 ODBC Linked Tables I have a user who gets an ODBC timeout message when trying to save a new record in a form. I looked at the locks on the server and that user was locking himself out. On the same server I can enter records fine with that form, except when he's...more >>

We are using SQL Server 2000 Standard ed, sp4 on Server 2000 Advanced. We have one table that is three times as large as the rest of the database. Most of the data is static after approximately 3-6 months, but we are required to keep it for 8 years. I would like to archive this table (A), but ...more >>

somehow i cannot migrate the database from ms sql 2000 to 2005, i recreated the same database name and exported the data from 2000 to 2005. THen what happend was all the default values that i set on tables are not transferred and stored procedures are not transferred. how can i duplicate the ...more >>

Hello. I hope someone can help me here. I work for a game company, and we have decided to drag ourselves kicking and screaming into the 21st century by creating all our data in a database. Since I have a little Access experience, I have been nominated to Sort This Out. So, what I need to do...more >>

Hi, I'm developing a software that makes a lot of access to a MS SQL Server. All information in the data base is decrypted and encrypt upon each read and write access -- this is causing a big overload of CPU in my system. I'd like to implement something to make it faster so I wondered if ther...more >>

Hi, This may be a little OT, but I don't know exactly where else to post it. I am writing a little parser that generates valid SQL using "English like" text. I want to use this to allow non-technical users to be able to quickly write their own queries, to search through a database that stores...more >>

Hi Is there any way to script a table (with EM or Management studio) along with data contained in the table (rows values)? J ...more >>

Hi, I'm making a translation thingie, that contains several languages. One of them is Danish and in one of my update scripts, I've come upon something strange. I have a text containing the letter "å" which is a special Danish letter (along with ø and æ). When I create the data base and insert...more >>

Hello, I want to select the names and number of rows of all tables in the current database, whose name starts with 'sys' my query is: select o.[name], sum(i.[rows]) as numbers from sysobjects o inner join sysindexes i on (o.[id] = i.[id]) where o.[name] like 'sys%'and i.indid=1 group by ...more >>

Hello, I have installed SQL Server 2005 Express Edition Advanced Services and SQL Server 2005 Express Edition Toolkit SP1. I cannot use full-text search. When I called: exec sp_fulltext_service 'load_os_resources', 1; exec sp_fulltext_service 'verify_signature', 0; go I got error: Ful...more >>

hi all, can anyone help me? I am a relative newbie to sql server and I am more familiar with Enterprise Manager than QA. I have made many many access databases though. I am making an asp.net application where by there are a set number of users, about 80, each one logs in and manages informat...more >>

Hi, I am having a SQL Server 2005 problem with my Insert statement. I am sending a command via my website to my database. It comes up with an error I'll put below. The code is here: "INSERT INTO tblUsers (userName) VALUES ( userNameTest)" This is the error I get: The name "userNameTest...more >>

On my development maching, I have three different SQL Server instances: ..\SQL2000 ..\SQL2005EXPRESS ..\SQL2005 When i try to debug a stored procedure in Query Analyzer, I get the following error: "Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Se...more >>

I recently generated a script using SQL Server 2005 for a local database that is configured as SQL Server 2000. Nevertheless, the script used the new structures and syntax (i.e., sys.objects vs. sysobjects). Is there a way that I can force SQL Server 2005 to use the old 2000 syntax? I notice ...more >>

Hi, I have a new job. It needs to drop and re-create (by insert) a table every night. The table contains approximately 3,000,000 (and growing) records. The insert is fine, runs in 2 minutes. The problem is that when I create the indexes on the table, it is taking 15-20 minutes. There is one c...more >>

I opened up Terminal Service Manager on my SQL Server to close out some ghost connections. Then I minimized the application. After working on some other issues. I right clicked on the minimized icon of Terminal Service Manager on my tool bar and closed it. Now when I go to Start/Admin Tools/...more >>

I've a database in 2000 which needs to be accessed from 2005 via linked server. I've tried the GUI options and it is failing. One thins is that our both servers have hyphen('-' not underscore, could that be a problem) in the names, like 2k-srv and 2k5-srv as hosts, but the instances are defaul...more >>

Hi All, I have a dillema that I created 2 transaction file before I started to take log back. Now I changed my recovery model from simple to full. Do I still need to keep my second transaction file? If I remove it would it be a problem for my system and log back up? If somebody responds me ...more >>

Hello, I am learning SQL Server 2005. I have (correctly) written in .NET assembly DemoSQLServer with aggregate function AvgNoMinMax in class Demo and I have added assembly to database DemoSQLServer. Now I need to create aggregate in SQL Server. I tried this way: CREATE AGGREGATE AvgNoMinMax(@...more >>

Try this script to see what queries are taking over a second. To get some real output, you need a long-running query. Here's one (estimated to take over an hour): PRINT GETDATE() select count_big(*) from sys.objects s1, sys.objects s2, sys.objects s3, sys.objects s4, sys.objects s5 PRINT G...more >>

I do software support for software that works with both Oracle and SQL Server, so I mostly just write queries to look at the data related to the software. When I first started, I bought a couple of books to learn the basics, intentionally going with generic books that would help with both types ...more >>

A lot of detailed discussion explains the difference between clustered and non-clustered indexes. But very few 'clarifies' why the term used is 'clustered'. Well, once and for all, this is my take. *** The 'CLUSTERED' adjective refers to the INDEX being clustered (set adjacent) to the DATA....more >>

I have a Windows XP machine that I have run SQL Server on in the past. I recently re-formatted the hard drive and re-installed XP from scratch, and now when I try to re-install SQL Server 2000, I get an error message saying that the "server component is not supported on this operating system...more >>

Hi All, i want to learn sql server 2005.can any body guide me as to which books to refer to and how to go about learning. Thanks a Lot. ...more >>