SQL Server

Page 1987




  • Topics
    Replies
    Last post
  • primary keys
    by Yongpil
    8 Replies
    Last post by Mike Kim
      • Hi there, is there any way I can use INSERT so if I try to copy duplicate primary key data, it automatically skips the task and moves on to the next data
  • How to know if a user has UNSAFE ASSEMBLY permission
    by sachin.dubey
    2 Replies
    Last post by sachin.dubey
      • Hi All, How can I know if a user has UNSAFE ASSEMBLY permission on master database by executing query. Please assist its really urgent, as I m stuck on this.
  • how to do this in SSIS? soory if i m a noob
    by brohans
    14 Replies
    Last post by brohans
      • Hi all, Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination. I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases): After 1st run, Source table has: 1 - 1000 records Destination table has: 1 - 1000 records For 2nd run, Source table has: 1 - 1500 records Destination table has: 1 - 1500 records Ho
  • Giant White Space Shows Up When Viewing In Report Manager Only
    by BenjyDog
    2 Replies
    Last post by P. Kenyon
      • Hello I have created a report that works how I want it in the visual studio 2003 designer. I have deployed it to our test box (sql server 2k, reporting services with sp2) and when we preview the report, there is a giant white space between the graph in the report and the matrix object below it. This white space was not in the designer. It only shows when previewing the report. If you print from
  • Why does SSIS think dBASE III tables are Unicode?
    by JeffJohnsonMVPVB
    1 Replies
    Last post by jwelch
      • Due to some legacy requirements, I'm using an OLEDB connection with the Jet driver and creating dBASE III tables (.DBFs) as the destination for a data export. The source is SQL Server 2000. The SQL table has a bunch of varchar columns, and I can't send them directly to the .DBF because SSIS complains that it can't (implicitly) convert from non-Unicode to Unicode. UNICODE ! dBASE III is ancient . W
  • "Could not find schema information ..." error in XSD annotation
    by mikeyblee
    13 Replies
    Last post by PMass
      • When I open any annotated schema in VC# 2005 Express, I get the error: "Could not find schema information for the attribute 'urn:schemas-microsoft-com:mapping-schema:relation'." Am I missing a reference   MSXML4.0 and the SQL Client are installed on my workstation. An example of one of the annotated schemas I've tried is this one, from Andrew Conrad's MSDN article "A Survey of M
  • AMO: Merging Partitions
    by Naggy_sr
    3 Replies
    Last post by Adrian Dumitrascu
      • Does anybody have a sample AMO code for merging two existing partitions through AMO Please help. Thanks, Nagy
  • Format DateTime attribute in AS 2005
    by Jeroen Alblas
    14 Replies
    Last post by Thomas Ivarsson
      • Hi, I have an attribute a Time dimension which is of the datetime datatype. In the browser and in other tools, the displayed members are formatted like this: dd-mm-yyyy hh:mm:ss I want to change this format. How is this done The format property of the attribute in the dimension editor seems to have no effect... I tried "mm/dd/yyyy" and without quotes. Thnx... Jeroen.
  • Import/Export Export Wizard
    by kschlap
    7 Replies
    Last post by futileNM
      • I'm trying to export data from a SQL Server 2005 database to a DB2 database through SSIS. However, I keep getting an error that says "Could not retrieve table list" with Invalid Conversion. SQLSTATE=07006. Does anybody have any ideas or what the problem could be -Kyle
  • execution plan question
    by Bob_Sullivan
    1 Replies
    Last post by Ryan Lamansky
      • I'm new to sql server 2005 and was reviewing the execution plan on one of my queries. I have a query that selects about 62,000 rows from a table of about 20 million I see there is a index seek indicated but further down the execution plan I see that a large percent is being assigned to a RID LOOKUP on the same table. Should I be concerned with this and if so, what would you recomm
  • Restoring a databse
    by SimonJohns
    9 Replies
    Last post by Jens K. Suessmeyer
      • I have a system running on SQL Sever and i am trying to create a second file on a diffrent computer so that I can teach people how to use sql sever (express) without risking losing any data that I have on my proper database. I have created a backup of my database which is in a dmp file and I would like to import this into SQL Server Management Studio Express so that I can make changes to the da
  • Puzzled by installation error.
    by leoku
    2 Replies
    Last post by leoku
      • I have tried installed several times the SQL Server 2005 Express (Standard or Advanced Services) on my XP SP2 system and all failed. The error messages are all about the Secure Socket Layer certificate and provider, either cannot find, create valid SSL certificate or the authentication provider is not trust (actually I don't know any of this and where to find them). I am learning at home the SQL S
  • how to do this in SSIS? soory if i m a noob
    by brohans
    14 Replies
    Last post by brohans
      • Hi all, Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination. I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases): After 1st run, Source table has: 1 - 1000 records Destination table has: 1 - 1000 records For 2nd run, Source table has: 1 - 1500 records Destination table has: 1 - 1500 records Ho
  • SQLServer dll's disappeared
    by dseydel
    2 Replies
    Last post by dseydel
      • When I removed/re-installed SQLServer 2005 (Express) all of my dll's related to SQL Server disappeared from C:\ProgramFiles\Microsoft SQLServer\90\SDK\Assemblies:  .ConnectionInfo, .Smo,.SMOEnum,.SQLEnum,.WmiEnum that I know of - maybe more.  How can I re-install these   Are they in the SQL kit, VB, SDK Any help would be appreciated.       
  • How can i change collation of userdefined datatype?
    by Cem Uney
    4 Replies
    Last post by Cem Uney
      • Hi everyone How can i change collation of userdefined datatype When i try to change it Management Studio Query varcharUzun = varchar(100) --> userdefined data type.... [code]ALTER TABLE tbxxxx ALTER COLUMN sDefinition varcharUzun COLLATE Turkish_CI_AS NOT NULL [/code] when i run the query it says. [code] Msg 452, Level 16, State 1, Line 2 COLLATE clause cannot be used on user-define
  • SQL Case limit?
    by DavidChai
    5 Replies
    Last post by PeteCarterGreenan
      • Hi, Just need to check with you on the following: sql 2000 sp3 sit in win2003 when we run the quere in server A.. it look okay with case expression more then 10 but when we run query in server B with linkserver to server A sql server give this message Msg 8180, Level 16, State 1, Line 1 Statement(s) could not be prepared. Msg 170, Level 15, State 1, Line 1 Line 1: Incor
  • Date parameter
    by Newguru
    1 Replies
    Last post by Shyam Sundar
      • hi and thanx in advance in a report, i am getting data from a stored proc which take to date parameter fromdate and todate which are passed from report. user select dates in datepicker control but problem is that it not returning any record Can problem be in date format difference in report and sql server
  • SSL To SQL Server 2000 From VB6 : Error
    by Ajay Suri
    4 Replies
    Last post by MING LV
      • Hi All, I am trying to connect to SQL Server 2000 database from my VB6 code. The SQL Server is having the setting ON to force all incoming connections to use SSL. It is using a valid certificate with the same name as FQDN of the server and has been provided by the security department in my organization. I have got my client code on my desktop. I have installed the root CA certificate for the
  • Set PreCompile property to False for RSExecutionLog_Update.dtsx
    by windthorstking
    3 Replies
    Last post by windthorstking
      • I have installed the Report Execution Sample reports and with it came the RSExecutionLog_Update.dtsx and instructions to enable it in a SQL Agent job. I have followed the instructions, however, where do I set the PreCompile property to false Is there a way to pull in a dtsx file into BIDS
  • Problems connecting to server using Management Studio
    by Peruukki
    5 Replies
    Last post by Peruukki
      • Hi all, I got this problem which makes me struggle in the last few days. I am able to connect to my local server using a query analyzer or calling sql commands in a window application, but there's no way I can access it in Management Studio: by clicking "Connect" it just waits forever, and it doesn't respond to any other command (it must be shut by terminating the process) Got any hints
  • Large database growth out of control
    by DaMack
    14 Replies
    Last post by Arnie Rowland
      • Hopefully I'm posting in the right area. There is a database that has grown to about 41-42 GB in size in about a 2 month period. The previous database had grown to about 22 GB before it was purged out. I'm running this on SQL 2000, and I've tried running all the DBCC SHINKFILE and SHRINKDATABASE commands to no avail. In this case, the MDF file is the one that has grown out of control as opposed to
  • System Administrator Privilege
    by Santhosh Pallikara
    2 Replies
    Last post by Satya SKJ
      • In SQL 2000, how do I grant system administrator privilege to "sa" or a Windows User
  • SQL Server Express with Windows Vista Business?
    by Dhow
    13 Replies
    Last post by Dhow
      • Hi y'all, I just know that SQL Server Express Edition SP2 is being released by Microsoft recently, and from previous informations I gathered; it seemed that SQL Server 2005 Express Edition is not compatible with Windows Vista (any editions). With the release of SP2, does this mean SQL Server 2005 Express Edition is now compatible with Windows Vista If so, do I have to install .NET Framewo
  • How to save for xml statement into a file
    by Lin Kejian
    1 Replies
    Last post by Arnie Rowland
      • Hi I have a T-SQL like : Code Snippet select * from customers for xml PATH , ROOT and how to save the result to a xml file .
  • Primary Key Help
    by Chris Cornell
    2 Replies
    Last post by Chris Cornell
      • Hi am fairly new to VS and very new to Access. I am managing somewhat. I have access to the database, I get inside my tables and I can change what needs to be changed. However I want to know how to work with primary keys. As of right now I am using 4 tables in my app. If i run my program all of the tables get filled in just fine. However if I run it again, none of the tables get updated because I