Hello.. I have a statement where I am looping through a result set of data and based on the sum I recieve on each item, there's an update statement made to the main table (in this case: invSUM) But for some reason I am not having any updates done. The final result "CSS_x" is of type: mo...more >>

Hi All, I am in a delima here. I have to a few backups restored from a set of backup file. The backup files have been removed from the drive because of some storage constrains... For some data comparison reasons, I need to figure out the actual date of these backup files that is used to res...more >>

I installed SQLH2 - followed directions closely :). All seem to work as described, except for the performance data. I am consistently receiving. 1/31/2007 10:32:55 AM INFO: C:\SQLH2\PerfCollector\Data\pfc013107072759.txt: fid = 16, state = 0, retry = 0 1/31/2007 10:32:55 AM Status: ...more >>

Hi, Is replication still available in SQL server 2005? I tried to search MS support website but can't find much information on it. Can anyone please give me links? Or is replication replaced by some other feature? Thanks. ...more >>

I have something strange with my Enterprise Manager (SQL 2000). When in my local server i cannot see my databases. The list is empty. If I go to Query Analyzer on the same box, I can see all of them. Also in EM, under the Management folder there is nothing to view. Any ideas what has happ...more >>

After seeing abnormally high load on the sql server this morning, i've been investigating. After ruling out the usual sources, i ran a trace on the DB, limited to showing only queries taking longer than 2000 miliseconds, only to find a constant stream of: WAITFOR (RECEIVE message_body FROM WMIEv...more >>

Hi there, I have added -t1400 flag in startup parameter in properties tab in sql server configuration manager. Then I restart the service. It has hung up for 30 minutes. Is this normal? Shall I wait? Or how can I terminate it properly? Thanks. ...more >>

Hi I just upsized a database from Access to SQL everything seems to be working fine except I had a Hyperlink field in Access which is not working with the SQL tables and I see no data type in SQL for hyperlinks. Is there a way around this? Any help with the will be greatly appreciated...more >>

Hi, What's wrong with the following code? Please help. I am using MS SQL 2000. create table one ( a float NOT NULL, b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) alter table one alter column a {drop} NOT NULL alter column b {drop} NOT NULL ; Thanks, Mike ...more >>

Hi, What's wrong with the following code? Please help. I am using MS SQL 2000. create table one ( a float NOT NULL, b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) alter table one alter column a {drop} NOT NULL alter column b {drop} NOT NULL ; Thanks, Mike ...more >>

Hi, I have the following sample code to alter two table columns. But it did not work. Please help me out. Thanks! drop table one ; create table one ( a float NOT NULL, b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) alter table one alter column a (NULL) , alter colum...more >>

I developed an asp.net 2.0 app using ss2005 on my server2003 system. my connectionstring is: "Data Source=(local); Initial catalog=mydb; Integrated Security=True" this logs me on under a user I created called aspnet that uses NT AUTHORITY\NETWORK SERVICE as it's login and everything works f...more >>

Hello, I would like to make intented error in the consistency of a database and watch what will be the outcome from the DBCC CHECKDB. Then train repair the database. I would like to corrupt some data or index pages in mdf file. How to do that ? Tanks. miso ...more >>

select convert(bigint,21568194 * 100) Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. Why does this happen, How do I fix?...more >>

I've got some data files from a utility company. The file is not just one record type, but can contain at least 3 record structures interspersed within the file. Right now, in MS Access, I open a text file, read it in line by line, and decide what to do with each line. How can I do this with...more >>

Hi all, I am trying to restore a DB which i have from on of my e-book. The DB format is .dat format. I am trying to restore this in the SQL server Express edition 2005 when i do that i am getting below error. TITLE: Microsoft SQL Server Management Studio Express ----------------------------...more >>

We are experiencing error in login connections during an automatic failover in a database mirroring session. Anyone who has had similar problem that can send suggestions/ideas greatly appretiated! Thank you ...more >>

Hello all In SQL Express 2005 needed to create 2 tiggers.. I noticed that the option to create was not working on the Database Tiggers folder in MStudio. I hand coded them and they are working.. I can see them in sysobjects.. .but they do not display in MStudio.. Is the is bug ? Which s...more >>

Thanks in Advance, I am seeing a strange behavior in the query interface on EM that is new for me, and it has only occurred in a new environment. So I believe that this is a configuration setting that one of you can point out to me. We I have multiple query windows open, if I turn my atten...more >>

How do you generate separate scripts for all the objects such as Tables or Store Procedures? This was an option in SQL 2000 ...more >>

Getting a linked server error. The way SQLServer 7.0 linked to 2000 allowed us to have both the ability to login under a given security context as well as specify individual logins. The linked server also contains the provision for impersonation in 2005. If possible, I would like to allow ...more >>

We are looking at the possible deployment of the SQL 2005 hot fix described in http://support.microsoft.com/kb/916002#appliesto to resolve connection issues with .net to SQL. However, we are unable to determine if this hot fix has any prerequisites (such as sp1), or if it fixed in sp1 or even in...more >>

How many bytes is a Row Identifier in a heap?...more >>

Hello, I would to create a backup file dynamically (the filename will contain the hostname of the DB). any idea how can I use a variable for that? (a variable is easy to use for a regular database backup, but not for a master key). I wrote on the comment the error I get. thanks, Yaniv us...more >>

I've got a huge performance issue with using Sql Server 2005 64bit. I have 130.000 files (+/- 15kB) that are offered to a webservice which logs the contents & additional info to a sql server 2005 (SP1) database. The throughput is disastrous. I'm not a sql guru and I expected sql server to be c...more >>

is there a way to add fields to a SQL Server 2005 table using an SQL statement? Thank You...more >>

I have a SQL Server 2000 database with the table listed below. I would like to write sql statement from the table listed below to display of the fields in the table using datediff function where begin_time - end_time is greater than 2 minutes. Please help me complete this task. Table ...more >>

Hello, I have a question regarding SQL Server disaster recovery plan. Lets say I backup quite regularily master, msdb, model and my databases. Is it enough to recover everything in case of dissaster? (I am concerned about the SQL logins and users). Lets say I have SQL login that maps to a Wi...more >>

I must be missing something, but how do you do this? select myintcol1+myintcol2 as sumcol from... Thanks! ...more >>

I have a query that contains a sub query. The problem is that the sub query returns more than 1 value so it fails with the error (Subquery returned more than 1 value). Here is a simplified version of how it is setup. Select * from table1 where column2 = (select col2 from table2 where column...more >>

I've got a user that needs to be able to get into the attach to the SQL database server (SQL 2000) from desktop engines I guess it would be to manage some databases. He was a user that used to have domain admin priveledges but I took those away so he wouldn't screw other things up. How can...more >>

Hi all, Can anyone tell me what the difference is between adding a unique constraint to a column, and adding a new index that is marked as unique? As I understand it, adding a unique constraint has the effect of adding a unique index anyway to enforce the constraint. If this is the case, ...more >>

Hello. I'm trying to update some 'text' data directly through SQL Server Management Studio (2005) on a table and have been encountering the following error popup: Microsoft SQL Server Management Studio No row was updated. The data in row _ was not committed. Error Source: .Net SqlClie...more >>

Hi, We usually just take the default settings for the model DB when we setup a server (SQL2000 and SQL2005). This means that an option like QUOTED_IDENTIFIER would be set to OFF. We would then create a database by either using a create SQL script or by restoring a database backup onto a s...more >>

Hello everyone, When I execute the following statement in the query analyzer on a msSQL2000 database... delete from DVD_I_Have where id in(select top 1 id from DVD_I_Have where Userid=78 and DVDID=8 and onhold=0); I get the following error... Server: Msg 21, Level 20, State 1, Line 1...more >>

I am trying to restore a database from a device, added a file and then when i press ok I receive the following error message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'server name'. (Microsoft.SqlServer.Smo) For help, click:...more >>

Is there a way to tell how many transactions my SQL Server will does a minute or sec or day. Any help would be great. Thanks, Nick...more >>

Hi there -- I'm a developer who mostly uses SQL Server from that perspective, not a DBA, and I had a client ask me a question recently that I couldn't answer. My client has a database that is updated constantly. A few weeks ago, he accidentially deleted about two weeks worth of data from t...more >>

Hi, I need to record all the updates on a table, like who, when and what. what's the best way to accomplish this? Thanks...more >>

Hi, I just created a tirgger. when I tried to drop it, it say "Cannot drop the trigger 'trigger_name', because it does not exist in the system catalog." But it shows when I query as: SELECT * FROM sysobjects o INNER JOIN syscomments c ON o.id = c.id WHERE o.type = 'TR' and o.name =...more >>

I'm currently doing differential backups via the following scheduled job command: BACKUP DATABASE [DATABASE] TO DISK = N'c:\backup\DATABASE- Differential' WITH INIT , NOUNLOAD , NAME = N'DATABASE differential backup', NOSKIP , DIFFERENTIAL, STATS = 10, NOFORMAT However, I'd like to do...more >>

Hi I have a web application that I need to create a view for each user and then destroy or remove the view after a report is generated. Just wondering if this can be done with stored procedures? Using SQL 2005. Thanks. -- Paul G Software engineer....more >>

I am using the Database Copy Wizard to copy a database from one server to the other. Here is the server information: Source Server: Windows 2000 Server SP4, SQL Server 2000 SP4 Destination Server: Windows 2003 Enterprise Edition SP1, SQL Server 2000 SP4 I initiate the DCW from the So...more >>

Hi all, Am trying to concatenate to fields with a spae in the middle using a couple of different methods: SELECT column1 + ' ' + column1 FROM... or SELECT column1 + SPACE(1) + column2 FROM... and both return: column1column2 Strangely this happens on the dev server, but works as inten...more >>

I recently started to log failed login for sql server 2000. When I check the log, I get "Login failed for user 'sa'" about 25 times a day. The timings of failed login attempts are consistent (always occur at the same time of the day). This server is behind the firewall. What may be the prob...more >>

I have a Windows 2003 server with SQL Server 2005 database server. I noticed that SQL Server minimum seeting is 0 and maximum is 2147483647. The database server has two very small databases. The server has 4GB of RAM. Periodically the average Pages/sec reaches a value of 20 for minutes. ...more >>

I'm trying to run a query to display all DB users who have not been granted access to any databases, but I'm running into an issue using the master.syslogins view in SQL Server 2000. I recently revoked access to certain databases for a few users using sp_revokedbaccess. As expected, these u...more >>

is there anyway to deploy a ss2005 db to a server and not enable local admins to see the source code for my stored procedures? -- Regards, Gary Blakely ...more >>

I have ~100 text files need to be loaded into ~100 different tables. These files need to be loaded only once. What is the best and quickest way to load this data ? SQL Server 2000 SP3a Thanks. ...more >>

Hello, I have SQL 2000 developer edition installed on a windows 2003 server with 4GB. I cant seem to make the server use more than 2.7GB of memory. I have the /3GB in the boot.ini file. But what other settings I need to do windows server and SQL in order to make it start using more RAM...more >>