3,481 Topics
 | |
| | I have an application that needs the report server URL for that application's sql instance. Based on the fact that it is an instance the report server URL should be: [QUOTE]http://servername/reportserver$InstanceName[/QUOTE] When I enter the above, on the server that has the SQL server instance, the web-page displays the report … |
| | Hello all, I'm having the following problem, I have three tables, Person, Income, Outcome Person has the primary key : ID Income has two fields : PersonID [Foreign] and IncomeAmount Outcome has two fields : PersonID [foreign] and OutcomeAmount I need to make a query that gets the summation of … |
| | hi friends I am new to SQL SERVER I am using sql server 2005 enterprise for server and express for client m/cs. Having issue while connecting from client to server. i have read some tutorials on net. while connecting to server from my client machine, i usually get error: 18452. … |
| | hi, i have 3 cols in my db col 1 ( unique identifier ) col2 ( varchar ) col 3 ( integer ) how can i retrive the 3 greatest values from the database on the basis of col 3.. |
| | I need some help creating a query that will pull a series of record that falls with a date range with specific interval. for example: I would like pass in a date like getdate() - 10 for start date and getdate() for the end date. However, the dates in between …  |
| | I am exporting a product table. I am exporting to a txt, tab delimited. I got the following error; Error 0xc020802e: Data Flow Task: The data type for "input column "ProductLink" (262)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT … |
| | Has anyone moved their SQL Server's into a virtual environment using VMware? If so, what has your experience been like? thanks, GM |
| | I'm starting to learn SQL Server. As part of that effort, I'm experimenting with accessing AdventureWorks sample databases. In database AdventureWorks, I've been accessing table Person.Contact. Although in that table there are columns for a phone number and an email address, there are no columns for a postal address. I … |
| | I’m trying to learn how to connect to an SQL Server database (I’m using the AdventureWorks sample database), but I’m having problems. Here’s the code I’m using: [code] // define connection string for database server string connectionString = "server=<server name>; database=AdventureWorks; uid=<user name>; pwd=;"; // no password // define SqlConnection … |
| | How can I uninstall the AdventureWorks sample databases? They're not an application, so I can't do it via Add / Remove Programs or a downloaded uninstaller. They're apparently corrupt, and they've been trouble from the git-go. The machine crashed when installing them. When I try to access them via SQL … |
| | Logfile of HijackThis v1.99.1 Scan saved at 13:55, on 2009-03-13 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16791) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\Ati2evxx.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\system32\LEXBCES.EXE C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\system32\LEXPPS.EXE C:\Program Files\Broadcom\ASFIPMon\AsfIpMon.exe C:\Program Files\Seagate\Basics\Service\SyncServicesBasics.exe C:\PROGRA~1\DIRECT~1\DUService.exe C:\PROGRA~1\McAfee\MSC\mcmscsvc.exe c:\PROGRA~1\COMMON~1\mcafee\mna\mcnasvc.exe c:\PROGRA~1\COMMON~1\mcafee\mcproxy\mcproxy.exe C:\PROGRA~1\McAfee\VIRUSS~1\mcshield.exe C:\Program Files\McAfee\MPF\MPFSrv.exe C:\Program Files\Microsoft SQL Server\MSSQL$ALAMODE\Binn\sqlservr.exe C:\Program … |
| | Assuming it can be done (as I've been told): How do I import ".mdb" (MS Access / OleDb) files (specifically, Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)? |
| | I've installed SQL Server 2008 Express with Advanced Features, but I've been having so-far insurmountable problems installing the AdventureWorks sample databases. However, I've successfully installed the Northwind sample databases, and I've downloaded the installer for the Pubs sample databases, so: Can SQL Server 2008 access Northwind or Pubs databases? |
 | Good Morning Friends, I have a SP that is Supposed to Restore a Database from a Backup. In some Clients this works well but in those particular client its a Problem. The version is SQL 2005. Here is the Code that fails [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go … |
| | hi I have got a table for internet accesswith user ID, it has 3 column user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet. can anyone please help me... thanks kaz |
| | After some initial problems with the prerequisite installation of SQL Server Express with Advanced Features, I tried to install AdventureWorks sample databases. Upon launch of the installer, Windows cited Microsoft as AdventureWorks' publisher. I confirmed to the installer that it should run. A dialog box then came up saying something … |
| | I am working on an ASP.Net website with SQL Server database and C# 2005 as the programming language. In my database I have two fields namely RDate and RTime. RDate stores the date of the record and RTime stores a time like 09:00 AM, 09:15 AM, 09:30 AM etc. The … |
| | Can I copy data from one database to another by a sql script? I have an active database we'll call dbo.active and a temp database we'll call dbo.temp both are a customer list and all the customers in dbo.temp exist in dbo.active. I want to copy the notes from dbo.temp … |
| | I heard of a sample database called Pub. Does anyone know about it? Is it an SQL Server sample database that, unlike AdventureWorks, doesn't require SQL Server's Full-text Search capability to install? That's what I need. |
| | djodjo1989 Hello everybody, First sorry for my english because i'm French, here it goes, i'd like to add a new user, for example HelpDesktop to the localgroup Administrators, for example. But i disabled xp_cmdshell for security reasons and i renamed the xplog70.dll DLL. I know the easiest would be to … |
| | I have an ASP.net 2.0 website with SQL Server as database and C# 2005 as the language. On my webpage I have a calender from which I choose a date and display only the date part in a textbox (readonly) in the format dd/mm/yyyy. But internally SQL Server uses m/d/y … |
| | Dear all I am asking about the MS SQL server certificates type & which of them I need as a web developer & what I need to study for passing MS Exam I wish an perfect answer & recommended tutorial I found a tutorial on for MS SQL server 2008 … |
| | Hi, I hope I am in the right place for this... I am looking for some help with a query. Basically, I am using a shopping cart which has option groups and I have created 2 new option groups. I now need to add these option group id's to all … |
| | I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem. Then I attempted to install AdventureWorks Sample Databases for SQL Server 2008 (SQL2008.AdventureWorks_All_Databases.x86.msi). This attempt failed because SQL Server 2008 Express, basic edition doesn’t support Full-text Search, which AdventureWorks requires. So I uninstalled SQL Server 2008 … |
| | I am developing ASP.net 2.0 website with SQL Server as database and C# 2005 as the programming language. In one of my tables, I have a filed named RTime of char datatype to store times. The values of this particular field are like 09:00 AM, 09:15 AM, 09:30 AM, ------ … |
 | Hello Experts, I am fairly new to MS SQL Server 2005. I am trying to create a table where a column has the restriction of allowing alphas only. I know how to achieve this in Oracle using String functions. But am not able to do so in MSSql. The replace() … |
| | I did a full installation of SQL Server 2008 Express. Looking at Add / Remove Programs, I see the following pertinent programs installed: SQL Server 2008 SQL Server 2008 Browser SQL Server 2008 Management Objects SQL Server 2008 Native Client SQL Server 2008 Setup Support File (English) SQL Server Compact … |
| | I have the following Stored Procedure which works for one client but not another:- [code] ALTER PROCEDURE spIssueScannedTickets @iEventID int, @MemberNum nvarchar(12), @BatchSize int, @FirstNumber nvarchar(12), @LastNumber nvarchar(12), @SlotsBalance int, @TableBalance int, @BonusBalance int, @UserID int AS DECLARE @Result int SET @Result = 0 BEGIN TRANSACTION if (@SlotsBalance>0) INSERT INTO … |
| | Hello all. When I run the statement: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%23%' I get the result: 2009-01-23 08:05:06.000 Administration Software is Closed. Operator's Name:admin But if I do: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where regdate like '%-23%' the result is null... why?!?! TIA, -hdmnp |
| | Hi, Data is stored like this in Varchar(2500) (with paragraphs): [code] Looking for NET developer, programmer. Required skills: VB.NET NET MsSQL XHTML If you are interested, please call "000" number's test. Thanks [/code] When i echo it, it is displayed like this: [code] Looking for NET developer, programmer. Required skills: … |
| | hi i need to know how to query a number of count on a particular table let say i have [B]emp_id[/B] and [B]emp_name[/B] field. on my table their are 2 records. the result looks this: rowcount | emp_id | emp_name 1 1000 albert 2 2000 leah is it possible? thanks, … |
| | i have only one coloumn in a table i want to dispaly all the datas in a row.Name of the table is student which contains only one coloumns slno Student Slno 1 2 3 4 5 I want to display them as slno 1 2 3 4 5 Thanks in … |
| | Hi All, I plan to have a website that has database connect to it. On my database, I want to display vietnamese characters (Input and output). How can I add vietnamese collation on my MS SQL Server 2005 developer edition? I am looking forward your help. Thanks. |
| | Hi All, I plan to design a website that uses for online news or magazine. I am having MS SQL Server 2005 Developer Edition. Please help me how to design a database. Please let me know where I can obtain information to design it or db diagram. Thanks. |
| | |
| | Hi, I have a table above 8.000.000 records. I am running a query like "select * from table where id=1093203". And the query turns in 24 second. This example i tested in SQL Server 2000 v8, Windows 2003 sp2. I am running same query in Windows Xp + Sql server …  |
| | Hey, so i have 4 tables i need to join together. basically this is how it looks table j: | id | uid | cid | text | | 1 | 3 | 1 | blah| | 2 | 1 | 3 | blah| table u | id | name … |
| | Note: I debated whether this should go in ASP forum or SQL Server forum and I think it belongs here. Ok, I have a classic ASP web application, a custom intranet, which has been used in 7-8 different installs, 3-4 different servers with no issues. It uses a SQL Server … |
 | |
| | Hello all, i have SQL 2005 installed. i have written a table-valued function getdepartments() which is as below: [code] CREATE FUNCTION getdepartments() RETURNS @departments TABLE( DNAME VARCHAR(25), DEPTID VARCHAR(10), DBONUS DECIMAL(7,2)) AS BEGIN INSERT @departments SELECT * FROM DEPARTMENT; RETURN END [/code] i need to invoke this statement from java …  |
| | Hello, I call the imagettfbbox function like so `imagettfbbox($font_size, 0, 'monofont.ttf', $code)` but its generating the following error: 'imagettfbbox() [function.imagettfbbox]: Could not find/open font' monofont.ttf is in the same folder. And the code executes fine on the server. It just won't work on my computer. This leads me to believe … |
| | Good Day All i have a table that carries a Field that has data like this [CODE] 10101010101010[/CODE] Now the Function that adds this 1's and 0's is working like this. If its selected insert "1" else "0", So if i can interpret the above if will be [CODE] 1 … |
| | Hi, I'm new to SQL Server. I just installed SQL Server 2008 Express. Then I opened Management Studio, right clicked on Database and created a new Database. Then I expanded Database, right clicked on Table and created a new Table. Now, my question is, how do I add data to … |
| | Hi All, We have a local MS SQL 2000 database which is daily updated by the users. We have a remote MS SQL database under windows based hosting. Now i need to update all existing data from local MS SQL to remote MS SQL database. I also need to find …  |
| | I cannot open regedit. I've run adaware, spybot, and AVG with no success. I downloaded hijack this, and here it what it found. Any help would be greatly appreciated! Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 12:28:17 PM, on 2/21/2009 Platform: Windows XP SP3 (WinNT 5.01.2600) MSIE: Internet …  |
| | Hi , I want to retrive the xml data into my database table. The xml file is from outside of application.so i want to retrive that xml data into database with in some temporary table Thanq |
| | Hello all, I have been tasked with figuring out a way to automate a form letter process that currently is done mostly by hand with a lot of copy/paste. We have letters that need to get sent out based on our internal system. Someone now looks up the items in … |
| | I noticed that my backup of my 2005 sql server didn't work over the weekend. I don't really know where to start as I haven't dealt much with servers. But I can tell you this.... SQL Server agent has a big red circle through it for not working on the … |
| | I'm new to T-SQL and trying to program a simple query: Table1 Location ID Flag Table2 (many to Table1) Location ID Code Select Table1 Location_IDs where the count of Table2's Code=value is 0 Thanks for your help! |
| | Hello everyone! I can`t find a solution to the following problem in SQL Server Reporting Services 2005. I created a table which has multiple columns. It can happen, that some columns have the same values for multiple rows, only the most right column has different values. For example Column 1 … |
The End.