2,935 Topics
 | |
| | Hello everyone! This is my first post on DaniWeb. Recently I have been working on a chart tracking system that utilizes MSSQL for a doctors' office. Now that I have finished it, I need a good way to deploy it across 50-100 computers in the office. The program will certainly … |
 | I am getting the following error sometimes. When the user load gets heavy I'll receive the following error. Would puting cftransaction around my update statements work? ODBC Error Code = 40001 (Serialization failure) DiagnosticsODBC Error Code = 40001 (Serialization failure Microsoft ODBC SQL Server Driver SQL Server Transaction (Process ID … |
| | HI I am very pleased to join this forum I am new to SQL programming , I am facing a challenge I need to copy the data from one table in one sql server to the same table in enother SQL Server From Server A table (Employee) To Server B … |
| | 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 … |
| | 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 … |
The End.