Microsoft SQL Server Forum

In propery page of view there is option "Bind to Schema" ,What does it mean and how does it work? Second:What is schema exactly? Thanks

Hi, I am using a SQLServer 7 SP4 version. I have scheduled one job with the SQLServer agent which backup the log of the databases every day. The command is : "backup log base to with noinit" At the end of the command, the logfile shrink from 20Mo to 1Mo. I don't understand because I though that only 'backup log with

From reading other posts, and modifying supplied scripts we have a CS server. Our new software package seems to need a CI database. The software developer says SQL is not case sensitive and our SQL must be broke. So ... How do I create a new database with enterprise manager with CI? We are running MS Windows 2000 Server for...

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

Hi All, We have started to get the strangest errors with our SQL Server. We use Windows and SQL Server authentication, and have done successfully for the last year or so. However last week i had trouble connecting to the enterprise manager with my domain credentials. Users connecting to Query Analyser have no problems when using their SQL...

Hi, I had this problem in version 7 and dont remneber How I solved it!! I have installed a local SQL Server (2000 aka version 8) on my Worksation (W2K), I have picked NT authuntication. Everything was fine untill I changed my password. Now SQL server can not start because it fails to login. The old password is embedded somwhere and I cant...

What methods are people using out there to keep their stored procedures under CM control? We are using CVS for our CM system. Looking for an easy way to get stored procedures scripted out as text so we can check in/check out of a CM system. Thanks! -- Mike Brown

When I run: select * from testtable I get this error message: Invalid object name 'testtable'. However, if I run: select * from testuser.testtable

Hi; I need some help in writing a query and the following is what I am trying to do. SELECT VALUE_ID FROM CC000.VVALIDITYVALUE WHERE (CATEGORY_ID = 2) The above Query will give will every Value_ID where the Category_ID =2. Then

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

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

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...

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...

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 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'...

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...

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)

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

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:

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...

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....

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"

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!!!!