[mssql] Forum Topics

I'm not sure if this is a Server 2003 issue or an MSSQL issue, so pardon the cross-post. I have created a local user called "sql-daemon" to run MSSQL 2005. At the onset, everything works fine: I can reboot the server and all SQL processes start as expected. Then, one …

Hi, I am not sure if my question sounds silly. I have a [B][I]table[/I][/B] that has a few columns like [B]date[/B],[B]source[/B],[B]race[/B] and [B]state[/B]. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number …

I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this?

Hi - this may seem like quite a simple query but i'm new to the SQL world... I have a column in my database (DB_Users) called Email - how would i go about extracting all of the email addresses in the column? I am using SQL Server 2005 and i …

Hi, I want to edit the sql server regestration. I want to change the Connection property from Windows authentication to Sql server authentication. But when I edit the sql server authentication with sa username and password, it gives error message saying that the [B]registration has failed for user sa, not …

Hi All, I am writing this just to even know if this is possible. What I would like to do is a UnGroup. Crap this is so hard to explain...okay I have a table in sql that is five columns long. The first Column is, ohh never mind. Copy and …

How do I find, alter, create, edit, etc. the stored procedures, triggers, and foreign keys on an MS SQL 2000 database? I'm trying to figure out how a given database maintains its referential integrity but I can't get behind the scenes on those things. I'm using SQL Server Enterprise Manager …

Hi,I'm new to daniweb forum. I hope someone could help. I have a table called [I][B]Caller[/B][/I] which has a field called [I][B]Area[/B][/I]. I need to select the value of the record in this field that [B]repeats the most[/B]. For example [B]Area[/B] Sel KL Sel Sel Pen KL which means i …

I have a DB which have three types of users: students, admins, and volunteers. I am trying to use SQL Server Enterprise Manager 8.0 to set up those roles such that students can (where appropriate) select, insert, update, or delete from given tables/rows; similarly for admins and for volunteers. (The …

Hi i try to sum two column in Sql, but don't get it.... this way is not working.... [COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#808080]+ [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])))[/COLOR] [COLOR=#808080],[/COLOR] and with that is not working to [COLOR=#ff00ff]SUM[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]DISTINCT[/COLOR][COLOR=#ff00ff]DATEDIFF[/COLOR][COLOR=#808080]([/COLOR][COLOR=#000000]mi[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_BEGIN_TIME[/COLOR][COLOR=#808080],[/COLOR][COLOR=#000000] dbo[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_HISTORY[/COLOR][COLOR=#808080].[/COLOR][COLOR=#000000]WORK_END_TIME[/COLOR][COLOR=#808080]))[/COLOR][COLOR=#000000] as A ,[/COLOR][COLOR=#808080] [/COLOR][COLOR=#ff00ff]sum[/COLOR][COLOR=#808080]([/COLOR][COLOR=#0000ff]distinct[/COLOR] [COLOR=#ff00ff]datediff[/COLOR][COLOR=#808080]([/COLOR]mi[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_begin_date[COLOR=#808080],[/COLOR] dbo[COLOR=#808080].[/COLOR]work_history[COLOR=#808080].[/COLOR]work_end_date[COLOR=#808080])) as B[/COLOR][COLOR=#808080],[/COLOR] sum(A+B) as Result can someone …

hi...is there anybody who has the right software for converting MSSQL to MYSQL?maybe u can share with me? please help coz im still very new to these fields.

Hi Gurus, I have little bit idea to Create a DTS Package to copy any 5 tables from Pubs to Northwind. but how can i do the following ..? Create a log table to store the package start time, end time, execution duration, records affected. When any transaction inserts/updates/deletes any …

Hi friends, As title refers, my problem is related with connection to the sql server. I use MSSQL Express 2005. My program, that is written in php, tries to connect to the server but the connection is failure.I didn't create an account from login under root and my connection type …

Latley we're having some strange behavior in some large databases. Sometimes the queries just takes a long time to run. They've run fine earlier. Is there a limit in rows/data that one should stribe to not exceed? It's on a fast machine with almost 12Gb free space. One table e.g …

I have 2 MS SQL Servers running on 2 machines that are identical. I am working with 2 databases - one from each machine. The structures of these databases are also identical however, the number of records are different.. SQL Server A has over 1.5 million records through which I …

Hi! I'm currently auditing a MSSQL database in my company. Is anybody know how to ensure that a particular MSSQL database did not use 'Alias'? Thanks!

How to debug a stored procedure in c#.NET IDE

Hello, I installed PHP 5 on my Server 2003 machine with IIS and got that working properly. I want to connect to my school's MS-SQL student database, but PHP balks when it hits "mssql_connect" (or whatever the statement is). How can I set this up so I can actually connect …

I'd like to know if I have to change security settings or something on my SQL Server in order to applications like ASP or VB to return a recordset. When my applications in VB or ASP return a recordset from a VIEW, I have not problems at all, but when …

Hi, I have a general question about MS SQL SERVER. We had sql 2005 express and got to the limit of 4GB. We then installed MS SQL SERVER 2000 and obviously have now a problem with transfering the database from 2005 express to 2000. Any advice? Thanks.

how to delete nth row of a table through sql query? please say me thanks, Arunachalam

My page displays the info in the text boxes, but when we run the click sub for the update button it returns the info that it has been updated sucessfully. Here is the page code and below that is the stored procedure it uses, but not update in the database. …

Does anyone know of any way to select only a certain number of records to appear on one page - say, like 30? - then having links to other pages of records if the number of records exceeds 30?

I have an app that performs scans and returns information like what windows updates it has, services running, programs installed, browsesr history, etc. Scans will be performed once a week and sent to a server. The server will only save the most recent scan and store the rest in a …

HELP - Invalid object error related to sqlole null bug in MSSQL 2000? We had a contract programmer come in last year to write a set of scripts in VB6 that select records from a MSSQL 2000 Enterprise Edition datbase table for display on a web site. Everything was going …

Hi All, I have a problem with a table level constraint i want to create. i have 3 tables: products categories product_categories - use to connect product to categories since a product can be added to more then one category. my problem is i want to create a contraint in …

Hi, I have a slight problem. I am trying to create a mail service for a new game which I have started creating recently. Each user that registers also creates a table for their mail. As the usernames are variable and the table name is the username, I need to …

I have a table to store the answers of users of our sweepstake. The table that consists of 3 fields: the userid, the questionid and the answervalue. Now I need to find the users with the most identical answers as a certain user. For example I may have values like …

In MSSQL "SQL server enterprise manager"(client side), I run query and application display record list, if I want to set a cell to "<NULL>" value, how can I do that with the hot key? thanks for any answer.

I have a table in MS SQL Server 7.0 Like this: Id Cat_Name Definition Image 101 A1 --------------- ************* 102 B1 ----------- ************* 101 A2 ------------------ ************* 103 C1 ----------------- ************* 101 A3 --------------- ************* 101 A4 ------------------ ************* 102 B2 -------------------- ************* 101 A5 -------------- ************* 101 A6 ----------------- …