I wanted to move my database log file to another drive, but unfortunately I executed wrong command . alter database ABC modify file (name = 'ABC_log',filename= 'D:\Program Files\Microsoft SQL Server\MSSQL\data\ABC_log.LDF') instead of alter database ABC2 modify file (name...more >>

Hi. I am getting started using SQL. My primary objective is to be able to write ANSI SQL statements at a high level, outside of a certain platform. I am using the book SQL A Beginner's Guide by Forrest Houlette. To get started, I downloaded the Microsoft SQL Server 2000 Desktop E...more >>

Hello. I have recently installed a second PC and it is connected via a LAN. I have SQL Server 2000 installed on my main PC but I wanted to access the SQL databases in the server from the other PC. Main PC running XP Pro, other PC running 98SE. I have installed the client tools on the 98SE but ...more >>

I am trying to remove the job but it gave me the following error. --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) --------------------------- Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. ----------------...more >>

why the following two query's results are different... any idea why? select count(*) from MedicalHistory where CDate between '01/01/2001' and '12/31/2001' 1728066 select count(*) from MedicalHistory where year(CDate) = 2001 1739088 Thanks in advance.... ...more >>

Hi, Can I restrict INSERT, DELETE, UPDATE, INTO queries in ADO? I get the query as input from user. Run it using ADO connection. Display the result in grid. However I want to allow only SELECT queries. Is there a property on ADO which allows this? Otherwise I will have to do the parsing mys...more >>

Hi, I have MSSQl 2000 , SP3 with WIn2000 when I transfer from one table to another, 115852 records, le server hangs. I tried with 70000 records and it worked. even with 90000 records. With more than 90000 records, the server hangs. Any idea ? It might be a bug in MSSQLsvr ? any know...more >>

I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I have no domain. I have two clients, one w2k Pro, sp4, and the other XP, sp1. I'm using Windows authentication. Neither can register my server. The error msg is the same for both: <mysvr> - SQL Server does not exist or acc...more >>

Hi All, We are using DAAB (Microsoft.ApplicationBlocks.Data) to execute stored procedure from .NET But at times we get the following exception "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". Would appreciate immediate ...more >>

Dear DBAs..... I would really appreciate if any one give me good advise for that. I had a table CustomerHistory in which there are 15 Billions of records. Basically in that table we are archiving the data for last 5 years and we use that table for reporting purpose. Cust_ID INT Ta...more >>

There was a MedicalHistory table in which contain 10 Billions of records so I did partioning into five tables and insert the data according to year. Now the problem is that when I run the stored procedure from the table(Medical History) it took 5 seconds and when I run the stored procedure throu...more >>

Want to findout the size of the table, how can I ? ...more >>

Select * into MedicalHistory_2001 from MedicalHistory where year(Creationdate) = 2001 Select * into MedicalHistory_2002 from MedicalHistory where year(Creationdate) = 2002 Select * into MedicalHistory_2003 from MedicalHistory where year(Creationdate) = 2003 Before using the above three c...more >>

Log file size continuously grows, even I placed Simple Recovery mode. Any one tells me, how can I prevent this problem?...more >>

Dear Professionals I want to ask one thing like my database recovery model is Simple and I am using Insert into table select * from table (3226303 records) Its filled up the log and my harddisk gone full, can any one let me know the solution like I don't want Log to be saved. ...more >>

Has anyone gotten SQL Server 2000 client tools (Enterprise Manager, ...) to install on a XP x64 box? Everything I have tried results in Setup running in memory, but doing nothing....more >>

how we can solve the table corruption problem ? Thanks...more >>

Hi We have an access app (both front & back ends are in access) that runs over win server networks. There are now more and more users who would like to take away a copy of app with them, work offline, and when they come back expect the client copy to sync (both ways) with the server copy. Seem...more >>

I am in a real bind - I need to locate and install the 16 bit SQL client on a system and I cannot find my copy of SQL v6.5. I have SQL 7 & 2000, but both of these packages don't seem to offer 16 bit connectivity. Does Microsoft offer any 16-Bit SQL client downloads? Any help would be g...more >>

The @@identity return the last inserted value in the database and the scope_identity return the last inserted value with that scope right ? ...more >>

Hi newsgroup I need to know the properties of all tables in a given database on MSSQL 7.0. I know that there is a stored procedure with the name "sp_MShelpcolumns" as well as another one called "sp_MSforeachtable". How can I combine these two to get a result that looks like: tablename, colu...more >>

WHAT ARE THE BENEFITS OF SCHEMA BINDING WHILE CREATING THE VIEW. ...more >>

Can anyone help me regarding the optimization of the following view because the dbo.vw_Main view calls vw_St_Un view and vw_St_Un view calls vw_S_OnS and vw_S_Tfer view... when I execute the Main view it take long time... can one give me his / her expert idea. thanks in advance. ___________...more >>

What are the major difference b/w rebuilding indexes and update statistics thanks ...more >>

Can anyone let me know like we need to rebuild all the indexes of all tables every day? or the specific indexes? Thanks ...more >>

Is it possible like when I create the database so it creates the database in C:\Data folder and log file at D:\log folder by default. I think we can do some thing in model database, if yes then can any one let me know how can I do this ? thanks ...more >>

What is the recommandation like how frequently we need to rebuild the indexes, every day ? Thanks ...more >>

I have by mistaken installed Named Instance, now I wanna convert this as a default instance, how can I? Thanks ...more >>

There is a Database Maintaince plan exist in my database but I want to check what this database maintaince plan do? Can I know through any command or query ? ...more >>

Can anyone let me know what are the best recommendation for optimizing SQL Server and database. Thanks ...more >>

Hye, I have client tools only, install on my computers. and I wolud like to use odbcping from my machin. does it possible to install the odbcping, because right now i dont have it install on my computer. Regards, Dubka....more >>

Can any one explain me regarding the following (Scan Density [Best Count:Actual Count] should be 100% right? ) I used DBReindex command but it's not growing till 90% - 1000%, what I have to do? DBCC SHOWCONTIG scanning 'Medical' table... Table: 'Medical' (1388284451); index ID: 1, database ID:...more >>

Migrating some code from a true SQL Server to MSDE. Keep having 'syntax problems near keyword error???' Any clues. Runs fine on old server....more >>

Hi friends, First of all sorry for my english. I have SQL 2000 server Sp3 on my network, i want know if is possible use a T-SQL table variable with adodb technology. The stantment that I want to execute is like this one: Dim conn : Set conn = Sever.CreateObject("ADODB.Connection") conn.C...more >>

We have a very simple select statement: select E.COURSE_YEAR, E.COURSE_SESSION, E.COURSE_CODE, E.FLAG FROM enrollment e where e.course_year=2005 and e.course_session=2 AND E.FLAG IS NULL There were 16743 records returned but more than half of them contain a value in the FLAG field....more >>

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1 rows have many duplicates col2 has unique values col3 can have 5 possible values: 5, 10, 15, 20, 25 Variable @V can be equal to 5 or 10 or 15 o...more >>

I have one table which name is medicalhistory which structure is as follows. ID int TId int TableName nvarchar(100) FieldName nvarchar(100) Comm1 nvarchar(4000) Comm2 nvarchar(4000) CDate datetime SCDate datetime The problem is that when I use the following query like. ...more >>

I have one table which name is medicalhistory which structure is as follows. ID int TId int TableName nvarchar(100) FieldName nvarchar(100) Comm1 nvarchar(4000) Comm2 nvarchar(4000) CDate datetime SCDate datetime The problem is that when I use the following query like. ...more >>

Hello, I have an application that use SQL server, (the conexion is not by nt autentification) I need to know what is the current windows user. Any help will be appreciates. Thanks Diego ...more >>

Hi friends, First of all sorry for my english. I'll be very happy if someone can help me. I am doing web page with vb.net and sql server, the problem is with registration. I am using user name and password which the user can set. The problem is that if I already have user with user n...more >>

- select * from sys.sysobjects where xtype = 's' return nothing - sp_mshelpcolumns 'sys.sysobjects' return nothing - sp_help 'sys.sysobjects' return this error Msg 15009, Level 16, State 1, Procedure sp_help, Line 70 The object 'sys.sysobjects' does not exist in database 'DBName' or is inva...more >>

Hi I have SQL 2000 server Sp3 on my network, i want know if is possible obtain major information from log file, i.e. if a user loggin to db i want know the time/date to login, operation excute etc. Can help me please Tia Pupo ...more >>

I have a users who uses SQL Query Analyzer to Access our Company live Database. How can I restrict him/her not to access our live database but instead give him a right to access the test database only. In the SQL Query Analyzer Drop down Database list can I make our live database invisible to t...more >>

Getting this error... SMS Client Configuration Manager cannot connect to the machine "ComputerName". The operating system reported error 1314: A required privilege is not held by the client. Possible cause: The client is not accessible. Solution: Verify that the client is connected to the n...more >>

We have recently upgraded our main server from NT4 to Active Directory (Windows 2003 Server). Our SQL Database is 2000 and is running on a Windows 2000 Server Box. We use com+ components to connect to our database. Since the change on our PDC to 2003 Server AD, we have had several errors su...more >>

I want to ask one question regarding copying the full backup, differential and then log into another machine and restore automatically but I want to know about the recovery mode I have to set on that machine so that only read and restoration can be take place and Yes I don't want to create t...more >>

Hi, I can't make a connection to my host's sql server via EM on a SBS 2003 server. I suspect this is because of the firewall. Any help appreciated! many thanks NEIL ...more >>

If I set the performance monitor alert on the production machine so is there any performance issue ?...more >>

Can any one let me know about the controller like in the optimization concern, we need to spearate our log file and data file into different controller, means sepearate physical hard disk What the controller is ?...more >>

I just want to discuss one thing with you like we have implemented RAID 5. In C drive all the softwares are installed and in D there is a storage device where all database mdf and ldf files stored now the question is that how can I set my mdf and ldf files into different controller so the s...more >>