I had to convert a database from VFP into SQL 2000. I have a primary key I have added, plus I have properly indexed the table as well. Unfortunately, I cannot create a query that supports the TOP clause. SQL Server keeps returning "Incorrect syntax near '100'" The user DBO has permissions ...more >>

Hi: I'm tearing my hair out with this! I'm trying to do a simple SELECT: select * from MyTable WHERE MyField = 'This field value has spaces' and it is coming up blank. If I look for any value without spaces, it gives me records. The field is varchar(32), and I'm using SQL 2000 SP4. ...more >>

I have a design question regarding the best way to handle the following situation for a custom CMS: -we have multiple users -each user has a private contact database -in each contact database, the user has a contact list that consists of both system standard fields (~15) (first name, last name,...more >>

Why would this query give me a problem UPDATE TABLE SET ALINK="FFFFFF" WHERE DisplayID=1 when SELECT ALINK FROM TABLE does not? I get this error message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'FFFFFF'. ...more >>

If I want to know the maximum number of GB a database will take up in SQL Server, what is the best way to determine that. Is there a standard sizing formula out there where I can plug in things like number of columns and maximum number of estimated rows per table (and any other important paramet...more >>

hi if i have ms-sql server standard edition with 5 CALs licensing - what does it exactly mean? 1. what exactly is a CAL? 2. is it so that if i have 5 processes actually running and the 6th one have to wait till one of the first 5 is finished? thanks Nedo ...more >>

we're updating currencies used in a database, so things like "US" become "USD". it's simple enought to run a few update statements on the tables where currencies are used to consolidate the old definitions to the new, but what about updating all the stored procs that still want to find currencies...more >>

How do I script foreign keys that include data on whether they are set to enforce for insert and updates. I currently have the following query that nearly does the job. select o3.name as ForeignKeyName, o1.name as ParentTableName, o2.name as ChildTableName, c1.name as ParentKey, c2.name as Ch...more >>

I have a column, and I want to make a SP to search for rows that have this column either starting with or ending with a given string, what is the fastest way of doing this? 'starting with' of course is easy i can do col LIKE @find + '%' but if i do col LIKE '%' + @find for 'ending with', i ...more >>

I'm trying to make a design decision however right now I'm deciding on the poorer (but easier) design simply because I can't think of a fast, and efficient way to query the data. Scenario: Basically we have accounts in our database with a set of FK which represent different states for the a...more >>

Hi all, I have a .NET application hitting SQL Server 2000 SP3a on the local machine, using Windows Authentication. This app uses SQLDMO to obtain a list of servers. Al l works fine on desktop machine. I move the app to a laptop (same configuration), but the app finds no Servers. A...more >>

I just installed SQL Server 2005 Express edition, but I can't connect to the server. The service is running, and I enabled all the protocols with the configuration manager. I tried connecting with the local installed SQL Express manager, and remotely with SQL Server Enterprice Manager, and Da...more >>

Hi Had to transfer all apps etc from a HD of a fried computer to a LapTop using PC Relocator. Most things transfered good except MS Developer Edition SQL 2000 Did an unitsall of SQL 2K when I saw it wasnt listed in the Services When I try to Install from the CD a message comes saying "A pr...more >>

i could write ddl for this one, but it would probably be pointless. but just in case, imagine a table: create table t1 ( id int not null, name varchar(50) not null, active bit, owner int, column001 varchar(50), ... column150 varchar(50), constraint pk_t1 primary key noncl...more >>

Hi, I have a table as follows: ID Description Parent 1 A 0 2 B 0 3 C 0 4 D 1 5 E 1 6 F 1 7 G 4 8 H 7 9 I 2 10 J 2 11 K 10 I'd like some p...more >>

Hi: I added this bit of code to my sproc and am getting the error "Incorrect syntax near the keyword DECLARE" and also "Incorrect Syntax Near ','". I'm tearing my hair out trying to figure out what is wrong. This is just the new bit of code, let me know if you need to see the whole sproc (@Se...more >>

Hi, I have created DTS package in the SQLServer 2000. Now, I would like to execute this package for multiple databases under the same sqlserver. How can I do that? I am trying to change it's connection's catalog property via VB.Net. But, It seems that it's not changing and everytime I am ...more >>

Hello there, I'm developing an application and have a number of requirements where I am trying to do quite a few financial calculations on a number of fields. I have gone against trying to store these as computed columns, and have tried views, but meet the problem that the maximum character ...more >>

Hi, Does anyone know a SQL statement that would remove all the \r\n (new line character) from a column in the database (if it exists)? Thanks Maz. ...more >>

My tempdb has grown to 40 GB and is growing my the minute but I'm unable to determine what process is to blame. If I look at tempdb..sysobjects all the objects are created very recently and change each time i rerun the proc. I would think that anything that has grown tempdb to 40 GB would have b...more >>

Hi Newbie here, How many computed columns do you recommend to have on one table? Richard ...more >>

Hi there. I'm looking for a tool that handles email sending from sql server with enterprise features. What do I mean excatly? It should be able to send emails easly from T-SQL. A simple extender stored procedure or blat is not sufficient enough. It has to be reliable, scalable, central reli...more >>

Hi to all, excuse my english ( i'm an italian student... ) I have the necessity of make a stored procedure that convert one parameter passed from base64 to binary before store in a field image. Is possible? How? I have this necessity because a lot of page made in ASP get the binary and p...more >>

Hi We have a SQL server 2000 cluster, built on Windows 2000 Advanced server. We are using an Active / Passive configuration which has 4 instances of SQL Enterprise, and 1 Instance of IIS. Both boxes are identical, and clustering works just fine. However, in order to use the 4Gb in each box...more >>

Hi, I'm executing a web application that calls a stored procedure and inside the sp I need to execute a BCP OUT with the xp_cmdshell. The problem is that I need to change all the application users as system administrators in order of execute the xp_cmdshell (this means that I have no security...more >>

I am trying to track down a problem of calling a stored proc from some ..NET code. I would ultimately like to be able to examine the log files to see what SQL Server is trying to run. I see from several other postings that examining the log file is not feasible. Since I am doing just devel...more >>

I want to have a list of available SQL servers (Not Databases) on my company network. (If possible for use with visual basic .Net) Thanks Menno ...more >>

I'm having some trouble understanding why SQL Server seems to be handling millisecond precision wrong. Consider the following sample code: ------------------------------ CREATE TABLE [dbo].[testdatetime] ( [my_datetime] [datetime] NULL ) ON [PRIMARY] GO INSERT [dbo].[testdatetime] (my_...more >>

the SQLServer diagrams are good for a quick view of tables and their relationships, but i'm looking for something with a little bit more metadeta in it. is there a diagram tool that will list the index, default values, and trigger information per table as well? something a little more visually e...more >>

Greetings. I have a database table with columns of type varchar length 80 that contain floating point data I'm trying not to lose any of. First of all I thought that numeric was appropriate for floating point numbers, but I don't see any decimal points or values in the output for numeric ...more >>

If I have a date (smalldatetime) column in a table, and want to get a result set where there is a row for every minute (even though no data point might exist for that minute), how would I do something like this? ...more >>