Microsoft SQL Server Forum

We have a SQL Server 7.0 database running with trunc. log on chkpt and select into/bulkcopy checked and need to develop a backup strategy. One of our DBAs insists that since the transaction log is being truncated, we can't do a hot backup (a FULL backup in multiuser mode) because if a transaction comes through during the backup it will...

Hello, We have a query which returns ~2.8 million rows. This same query is used in a DTS package, which exports to a text file. The number of rows in this text file, however, is ~2.7 million rows (I'm rounding of course.) So a good chunk of data vanished in the export it appears. Using SQL Server 7.0 on Windows 2000. Anyone see bugs...

Sapeto dove posso trovare una tabella sql con l'elenco di tutti i comuni magari aggiornata al 2003? Cerco una versione che contegna questi campi: Codice, Denominazione, esistenza, targa_provincia, cap, prefisso, codice_istat, codice_imps, Codice_Info_Camere, Codice_CPI So della sua esistenza perché ho un cliente che la possiede e non la...

somebody helps ? 1.What kind of lockes are created on what resources when following querys executes ? select * from JOBQUEUE where ID='XXX' update JOBQUEUE set columnA='YYY' where ID='XXX' 2.Under what kind of situation, share lock on a row or on a page or on a table will convert to exclusive lock?

Hi, We have a unique situation here that is puzzling me. I have a program that uploads data to our SQL Server. The program runs fine on WIndows 95. I have installed it on a Windows 2000 machine and it will connect to our data but will not upload. It processes the file but the data does not appear in the database. I have checked the...

Access 97 SR 2 Front End SQL Server 7.00.1063 Back End When I attempt to relink the tables in my Access app. I am suddenly getting this weird error message = "ODBC--Call Failed", followed by "Restricted Data Type Attribute Violation(#0)". This problem did not manifest last time I tried a few weeks ago, and so far as I know there have been...

I have a question with regads to placement of data files/indexes on multiple filegroups. Here is the current scenario: I have a database comprised of two filegroups - PRIMARY and INDEX. The PRIMARY filegroup is comprised of two files, one residing on the R drive and another residing on the O drive. The INDEX filegroup consists of a file on...

I've got a field that can be a foreign key on the table *OR* the table depending on the value of (see "Structure," below). Question 1: Is this poor DB design? Question2: If this is okay DB design (or, if I can't change this DB), how do I perform a join? I started writing a sproc (see "Beginnings of sproc," below), which will...

hi folks, i'm puzzled over this one, anyone with some solid db experience might be able to enlighten me here. i'm modelling a file system in a database as follows, and i can't figure out to cleanly implement an inheritance mechanism. i have a hierarchy of folders in an sql table. every folder has a parentFolderID, if this value is 0...

We are having some troubles with corrupt indexes on our SQL 2000 dbase. It is only affecting 2 tables out of about 150 we have. These 2 tables are heavily used. We have run dbcc repairs; dropped and recreated indexes but the problem persists

Is there any reason why SQL Server (EM) would go through all the motions of a restore and not actually do anything at all? To get into this situation I backup from a client's server and download that backup to my server where I restore it, as I hate having to type in the physical path names each time what I did was backup my old copy to a...

Hi, Can anyone advise me of a quick way to estimate the time taken by DTS to import a table (24 columns x 700,000 rows) from JD Edwards (running on AS400) into SQL Server (new table and no manipulation involved)? Many thanks, Steve

SQL Server Enterprise Manager could not start the service 'MSDTC' on server 'NTAS21'. 1722 - (The RPC server is unavailable) I Setup A publication on a server called NTAS4D, then Pushed The Subscription to another server called NTAS21. If I configure so that the changes at the subscriber are not replicated to the publisher, all works ok,...

What is the documented and known behavior of inserting hex constants into a binary/varbinary column from a client to a server which have different code pages? Will any code page / character set conversion take place? eg: insert into t1 values ('AA') or insert into t1 values(x'AA') Thanks Aakash

Hi, I am looking for an email address management software package that can do the following: 1. Mail Merging / Demerging capabilities... a). I will be adding to my list of email addressses from time to time. I need to make sure that I do not send an email to a person/company that I just sent an email to earlier.

Hi, i need to round: 3° decimal between 1 and 5 LOW 3° decimal between 6 and 9 UP Thanks

I need to loop through a set of records to build a string. I can do this without using a cursor by inserting the records into a temporary table with an identity column. Count the number of records in the temporary table and loop though the table selecting the values and building the string where the identity column = the loop number. Is...

I have a problem with executing following T-SQL select query. My select statement looks like this SELECT * FROM (@TableName_FirstPart + @TableName_secondPart) **@TableName_FirstPart & @TableName_SecondPart are Local variables** Im getting Incorrect syntax error for this statement.

Hi All, I have a stored procedure. I need to create a scheduled job using that stored procedure. I went to Enterprise Manager -->Management--> Jobs-->New Job Properties

Hello All, Is there a way to run sql select statements with column numbers in place of column names in SQLServer. Current SQL ==> select AddressId,Name,City from Address Is this possible ==> select 1,2,5 from Address Thanks in Advance,

Can anyone help me??! What is the best way to import data from One World into SQL Server? If it's possible to use DTS then should I use the OLEDB connection object? Many thanks, Steve

I am designing a WEB BASED Accounting Software with ASP and SQL Server. For this I need some help for the Database design. My design is as follows. I)User table: User_id, UserName..... Users (e.g. John Smith) Each User would contain a following Group of tables a)Customers

Dear sir I have one SQL Server database. In this database more than 20 tables exists that their structures is same. I have two way for design this tables: 1.Create all tables separately(create more than 20 tables) 2.Create one table and separate each group by type(add column type to table and assign same value for each group)

I have a database connection in Frontpage 2002 to a SQL 2000 server called call_log. The database is call_log and the column in question is employee. I have designed a secure employee website that runs on IIS 5.0. It uses Client certificates as authentication. I have an asp page for each salesman that queries only their Call Logs. Is...

I need to connect to several .dbf files every day and retrieve its information in a job every morning. Right now I run a seperate program to export the .dbf to text and then I BULK INSERT them in. I would like to skip the seperate program and do it directly. Anybody have an idea of how to create a connection to those tables? Any help...