-
- Auto incremented integer primary keys vs varchar primary keys
by Pikker1981
- 7 Replies
- Last post
by Pikker1981
- Hi, I have recently been looking at a database and wondered if anyone can tell me what the advantages are supporting a unique collumn, which can essentially be seen as the primary key, with an identity seed integer primary key. For example: id [unique integer auto incremented primary key - not null], ClientCode [unique index varchar - not null], name [varchar null], surname [varchar null] isn't it
-
- ADO.NET Transactions causing Deadlocks???
by Anonymous553253
- 0 Replies
- Last post
by Anonymous553253
- When my web server is under heavy load (90% cpu utilization and high contect switching) I am getting deadlocks in my database. All of my transactions are controlled from a data mapper layer using ADO.NET transactions. Most of the transactions look something like this....
Code Snippet
using ( TransactionScope transactionScope = new TransactionScope ())
{
try
{
-
- How to upload / publich a MSSQL database
by el patsale
- 5 Replies
- Last post
by Mike Wachal - MSFT
- Hi all!
I am a newbie with SQL Server and need some advice. I have developed a small database with Microsoft SQL Server 2005 Express on my local computer. I am using it in conjunction with SQL Server Management Studio Express. Now I want to upload it to an online web host. What is the best way to upload Do I use replication or some other means Can I do so with Management Studio Express My
-
- Please vote/validate SQL SSAS bugs on connect.microsoft.com
by mobigital
- 1 Replies
- Last post
by Edward Melomed
- Folks, It might help to get SQL 2005 issues addressed in more expedited fashion if we go to https://connect.microsoft.com/SQLServer (Click where it says "1. Click Feedback here " to enter feedback area. search for analysis services bugs review bugs that are filed rate bugs by voting validate bugs that you've seen.
-
- How do I capture the error message from a stored procedure?
by BlackCatBone
- 6 Replies
- Last post
by Phil Brammer
- Greetings,
I am creating a package that has many SQL tasks. Each task executes a stored procedure. I need to capture any error messages returned by the stored procedures. Eventually, the error messages will be logged so that we can audit the package and know if individual tasks succeeded or failed.
I'm not sure where or how I can access a stored procedure message. What is the best
-
- .NET Custom UDF - "Internal error: An unexpected exception occured."
by Yuri Abele
- 13 Replies
- Last post
by Anand Soni
- Hi!
I have developed some .NET UDF for MSAS2005. I compiled it, added assembly to database and tested it - it works. But works only on my test seerver. On life server I've got this message: "Internal error: An unexpected exception occured." Assembly is registered as unrestricted. I've maid simple test function in own assembly file, which just gives back 1. It also works on test- and does not wo
-
- SSIS training?
by Loopsludge
- 4 Replies
- Last post
by LarryETL
- Greetings all, I have a need to quickly spin up on SSIS. Can anyone suggest a class I did a search on this forum but most of the the related threads were not all that recent. Thanks in advance.
-
- SQL 2000 -> SQL 2008 Upgrade Possible?
by namraja
- 1 Replies
- Last post
by MVP User
- Sorry if this has been asked before (but I can't see a thread on this topic). Any thoughts if it will be possible to 'upgrade' your SQL 2000 databases to SQL 2008. Or will I be forced to upgrade these legacy databases to SQL 2005 first Thanks
-
- query to xml question
by Seidel1
- 6 Replies
- Last post
by Konstantin Kosinsky
- I have a table that contains 3 columns SiteID, Results and date. the table has 4 rows. I want to query the table and end up with 1 row that combines all the field into in the Results Column.
so in table form it looks like
627 test 3/3/7 627 bob 3/3/7 627 tom 3/9/7 627 rob 3/8/7
I want the resulting query to bring back one row:
test,bob,tom,rob
the following query will do 90
-
- Transactions and Create Table statements
by Ralf_from_Europe
- 4 Replies
- Last post
by jaegd
- I have some problems getting my SSIS package to run in a transaction, I wonder if anyone can assist.
What I want to do is run one package, which consists of a
- 1) create staging table SQL statement
- 2) read (all) from Access MDB to staging
- 3) copy (only new) from staging table to real table
- 4) drop the staging table
I changed the package to "require" a transaction
-
- Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation.
by EnvisionOne
- 14 Replies
- Last post
by Xinwei Hong - MSFT
- I'm trying to use SQL Management Studio to connect from a Vista SQL 2005 client w/ SP2 over to a Windows XP workstation running SQL server developer edition (non-sp2) using windows authentication.
I'm already preauthenticated by network shares to the xp workstation. This worked just fine in windows xp but stop working in vista.
After searching around, i found out that vista handles t
-
- Stored Proc takes 45+ MINUTES!
by DeborahK
- 5 Replies
- Last post
by DeborahK
- Hi guys -
I have been googling all day and not found a reasonable solution to my problem.
Here is what I am trying to do. The T-SQL code is included at the bottom of this message.
- The user can specify columns that are stored in a CVColumn table (the data for which comes from an external source). For example, we may provide LastName and FirstName columns and the user could ad
-
- How to search in Table's XML Content?
by devsem
- 2 Replies
- Last post
by devsem
- Hi ! I've one table with XML field which stores the another temporary table in XML format now I want to search the data from the table's XML content.... Like, data in XML field is < xml version="1.0" encoding="UTF-8" > <root> <dynamic-element name="Keywords" type="text"> <dynamic-content> <![CDATA[Moushumi Chatterji, Rani
-
- sql to access
by bikash
- 5 Replies
- Last post
by bikash
- hi i am trying to load sql data into ms access. in access there are around 30 fields with auto number, memo,datetime and text data type. from sql i am trying to load about 10 columns that doesnt include autoids. all the data type are in varchar and date time etc in sql data type but i do cast to ntext and then i format the data length etc according to ms accesss so that meta data is valid but havi
-
- Installing SQL Server Express
by Jim Hess88
- 10 Replies
- Last post
by Mike Wachal - MSFT
- I have installed SQL Server Express on a Windows XP Professional workstation. The installation instructions that I was following said that I had to have .NET Framework 2.0 installed. The instructions said that I should uninstall any versions before I tried to install 2.0. My computer already has version 2.0 and version 3.0 installed, so I did not remove anything. My problem is that now that I have
-
- Cannot add DM add-ins
by Tim Steeno
- 13 Replies
- Last post
by Thomas Ivarsson
- I have had so much trouble with these DM addins that I feel like giving up. Maybe someone here can help me. I finally got the DM Add-ins installed last week after contacting MS Support to help. I had them running for the last week with no major issues. Today I tried to load Excel and the Data Mining and Analyze tabs are missing from the Ribbon. I checked Add-ins under Excel Options, and the Add-in
-
- share report
by zwp
- 14 Replies
- Last post
by Prash Shirolkar - MS
- I got the following in my report server log:
w3wp!library!1!01/29/2007-17:15:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report
-
- Excel 2007 and OLAP Server Formatting
by cka11
- 2 Replies
- Last post
by cka11
- Hi,
I can't make Excel 2007 to apply on percent number format.
I use the CustomMemberOption on my calculated AS2000 members. It works great for number formats like FORMAT_STRING='0.00' but I can't get Excel 2007 to apply on FORMAT_STRING='percent'. It works great in ASManager browser.
Any idea
Thanks, Christer
-
- RecordSet into a DataFlow Task
by Cordell Swannack
- 8 Replies
- Last post
by Cordell Swannack
- In the control flow I have an "Execute SQL Task" that executes a stored procedure. The stored procedure returns a result set of about 2000 rows of data into a package variable that has been typed as Object to contain the data.
What I have not been able to figure out is how to access the rows of data (in the package variable) from within a data flow task. There does not seem to be a da
-
- scheduling SQL Agent
by Abhi T
- 14 Replies
- Last post
by jwelch
- I developed a package,configuration file on my machine i imported the packages on to the SSIS msdb folder, i am scheduling the package by using SQL Server Agent, Jobs while scheduling i got the error
Executed as user: user. ...cute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:14:00 PM Error: 2007-10-23 15:14:00.19
-
- Changing HOME folder per user
by Vlad_OM
- 9 Replies
- Last post
by Lukasz Pawlowski -- MS
- I am wondering how I could do the following - Right now the default folder is Home, what if I have two users User1 and User2, my folder structure is the following - Home/User1 Home/User2 I want each user to only have access to their folder. That is easy to do. Once both users have proper access to their folders they still don't have access to Home folder. In Report Builder when I do 'open file' it
-
- Variables in Script Task
by ubear
- 14 Replies
- Last post
by sundhar19
- I recieve the below error when I attempt to execute a Script Component in a Data Flow Task:
The collection of variables locked for read and write access is not available outside of PostExecute.
This is the code I used:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
-
- IN CLAUSE
by jortiz
- 7 Replies
- Last post
by Rob Farley
- Hello, I think I'm getting something in SQL SERVER that is none sence for me at least...
Example:
SELECT * FROM A
WHERE A.ID IN (SELECT B.ID FROM B WHERE A.NAME='ABC' )
This query is returning DATA and It works... in SQL SERVER 2000
Can I invoke an external table in a subquery that is using IN clause
This is not possible in many other DBMS... I don't know if this a B
-
- MDX Filter Problem
by Summa
- 7 Replies
- Last post
by Mosha Pasumansky
- Hi, I am using AS 2000 FoodMart 2000 DB . My problem is when I run the below query I am getting an error. Query 01 SELECT {[Measures].[Unit Sales]} ON COLUMNS, {[Product].[All Products]} ON ROWS FROM [Sales] WHERE [Product].[All Products].[Drink] ¡° Duplicate dimension across (independent) axes when calculating a query axis ¡± But it is understood that I can use any other slicing dime
-
- Job scheduling for Packages in SQL Server 2005
by luzippu
- 14 Replies
- Last post
by Phil Brammer
- ---------------------- MS Win XP Pro 2002 SP2 MS SQL Server 2005 MS Visual Studio 2005 ----------------------
Can anyone help me (even by pointing me to a documentation) in order to schedule Packages (from file system source) in SQL Server 2005.
I've configured providers logging, but still the error file doesn't give me any explanation why the error happens: "#Fields: event,computer