Microsoft SQL Server Forum

I have a client who was installed improperly on a Case Insensitive Collation SQL system and have been working with this system for over a year. For them to move forward in application software versions, they will need to be reinstalled on a Case Sensitive SQL system. I was wondering if anyone has tried this and was willing to provide...

Hello, I hope you guys can help me with a problem that I am facing... I have started the MSSqlServer service and SQLServerAgent services with a domain username and password. There are periodic password resets to this user. Security policies within the company dictate that the password for this domain account cannot be permenant. Would...

Could some database expert post some information or link about that? thanks Janusz

Yesterday I received a response to my CI/CS Collation problem and the recommendation was to try and restore a CI Collation database to a CS Collation database. After creating a blank CS database a full restore (Force restore over existing database) does change the Collation to CI. I'm unsure as to how I can restore without changing the...

We currently have a bit of VB code that gathers data from different sources (tables from 2 different SQL Servers and some basic algorithms) and places this data into an Excel spreadsheet. This spreadsheet is then massaged then sent to a client. The client can then sort the data many different ways to make decisions. We want to move this...

Hi all, I received the following email from a work colleague. Any help with this would be greatly appreciated. ----------------------------------- Can you please post the following question on the MS Bulletin Board relating to SQL 2000 Analysis Services.

Got a tough one here for you SQL junkies. I'm working on a website (in ASP) for a national greek/college organization. All it's college chapters have greek chapter names, i.e. Alpha Chapter, Delta Chapter, Delta Iota Chapter, Gamma Phi Chapter, ect. ect. I need the SQL to return the chapters in greek alphabet ordering. See below: 1....

This is a (*) PERSISTANT (*) UNRESOLVED (*) ILL EXPLAINED PROBLEM WITH SQL SERVER. THE POSTED WORKAROUNDS DO NOT WORK. THE SUGGESTED SOLUTIONS ARE IDIOTIC AND BASICALLY MAKE EVERYTHING WRITTEN ABOUT DTS USELESS!!!!

I have the following code snippet: sql = "select * from customer where code = 'abc'" conn.BeginTrans With rs .Open sql, conn, adOpenDynamic, adLockPessimistic, adCmdText If Not .EOF Then ' --- Force edit mode --- !Code = "def"

I have a table as follows: - user_id (key) - user_email_address (text) - user_request_date (text) - user_sent_date (time/date) An automated macro will run every 5 minutes and needs to run a SQL UPDATE that:

How to generate a seq number in TSQL. My need is for every record insert ,I need to insert a seq number paded with letter 'I'. Please help me. Adv Thanks mate -- Posted via http://dbforums.com

Hi, I have a text file that contains a date column. The text file will be imported to database in SQL 2000 server. After to be imported, I want to convert the date column to date type. For ex. the text file look like Name date Smith 20003112

Hi all! I hope anyone here can help me with this tough problem: I have a replication enviroment with several subscribers. Publisher:MSSQL 2000, SP3 Subscribers: MSSQL200, SP3 and MSDE2000, SP3 Since a few weeks, one of the subscribers fails when synchronizing with the message

In the hereunder written message I talk about point in time restore. It is now based upon the fact that there are no hardware problems or what so ever. I just would like to roll back to a situation of some time (minutes, hours or what ever) ago. Used to the ingres database a point in time restore can take place UP to any, any, any time...

Hi, Sorry for completely newbie questions :) * Can you recomend me internet resources on MS SQL Server stored procedures? * Can MS SQL Server's stored procedures do the same things as Oracle's (I was programing with PL/SQL briefly few years ago)

Hello Im am a sql newbie who has a question concerning triggers. Ive made this trigger: create trigger check_if_already_exists on users for insert ,update as begin begin transaction

I have a problem within a procedure I am working on. I would like to process every column in a table in a cursor. Now to my problem, I can't save a column of type text into a cursor variable. It's not allowed to use datafields of type text in this context. I also think that I runned in to a simular kind of problem when trying to use text...

I am trying to implement a very fast queue using SQL Server. The queue table will contain tens of millions of records. The problem I have is the more records completed, the the slower it gets. I don't want to remove data from the queue because I use the same table to store results. The queue handles concurrent requests. The status...

WIN2000 sp4, SQL2000 sp3 I created an alias on the local server for the SQL 2000 server installed there, I can view and modify most sql server properties using this alias, but when I attempt to configure the local sql server for replication, as both a distributor and publisher, I receive the following message - "Error 18483: Could not...

I am a SQL newbie! What is the correct datatype to use, if I want to record a checkbox from a web form? Thanks, Darren

I am trying to transfer with dts a table of As400 into a db sql-server. But i receave un error (2147217865) With Access i can import the table with the same ODBC. You have some suggestion ??? thk by Logan bye bye

I am working on bringing data into our SQL Server from a btreive database through Pervasive. It seems to work, mostly, but I am having problems with dates. At first, all date conversions from btreive field type Date to SQL Server SmallDateTime would produce nothing but errors of this sort: ActiveX Scripting Transform 'DTSTransformation_1'...

I'm new to SQL and databases and have a delema which I'm sure is an easy thing for you experts out there to do. What I have is this: I have a table similliar to this: table name: tablename columns: date, name, purchased Within that table the following data resides: date name purchased

I need to generate a random whole number between 0 and 999 to add to add to every record in a table. The number needs to be different for each record in the table. How would I do this all within TSQL?

Hi Guys, I find there is memory leak in our SQL 2000+SP3 databass. We have a client-server system, and the there are Jrun4.0 running JSP and someother Java application talks to the database. However, for only less than 40 users, the SQL 2000 memory usage will increase consistantly until it use all the memory it can get ,about 1.7G...