SQL Server

Page 2513




  • Topics
    Replies
    Last post
  • Cannot Pull table with RDA
    by beholder
    14 Replies
    Last post by beholder
      • Dears, I'm trying to set up a rda connection through the pocket pc emulator (standalone version 1.0) and my laptop which runs Windows Vista Home Premium. To start up the rda I first need to connect from my emulated device to my laptop which runs IIS 7.0 (complete installation with compatibility toward IIE 6.0). Connection to http://localhost from my laptop is working fine. I start the emulator (Po
  • How to connect to remote server
    by Jay Khanpara
    3 Replies
    Last post by Mike Wachal - MSFT
      • Hi All, I have created my sql database script using SQL data publishing wizard, now i want to execute the same on my shared hosting database. But i am not getting any option to connect to remote server in SSMSE. I have developed web based application with back hand as SQL Server 2005, so now i want to execute my script file onto the server. so how i will connect with my server using
  • SQL 2005 Standard on Vista RTM
    by GFlexman
    14 Replies
    Last post by Ron Chrisope
      • Hi All, I've read a number of threads on here where users have managed to get 2005 working on Vista RTM. I'm having no such luck however. The issue I have is as follows: Clean Install of Vista RTM Ultimate 32bit. Attempt to install 2005 Standard. This error appears: SQL Server Setup Failed to compile the Managed Object Format (MOF) file D:\Program Files\Microsoft SQL Server\90\Sh
  • Performance-Issue with variables
    by Tilfried Weissenberger
    3 Replies
    Last post by Arnie Rowland
      • It's weird, but the literal (untyped) version is faster than the version with the paramenters. Occurs with SQL 2005 SP1 64bit how come --FAST!!!! See execution plan SELECT count (*) FROM dbo . NewsComponent ttNC WHERE ttNC.DateImported BETWEEN '2007-04-02T00:00:00' AND '2007-04-03T23:59:59' ) --( ttNC . DateImported > '2007-01-01T00:00
  • cannot connect to server
    by sally568223
    3 Replies
    Last post by Jens K. Suessmeyer
      • i have installed SQL Server management studio when i attempt to connect to report services server i get the following error client found response content type text/html;expected text/xml i cant find where i might have went wrong in installation or report server configuration am new to reporting services so plz help me on this regard thanks sally
  • using encryption via an asp site. how is it done
    by winstonSmith
    4 Replies
    Last post by winstonSmith
      • ive been playing around with encryption, just encrypting a column with a symmetric key, and having that symmetric key encrypted with a cert, and all that , and it works well through the SSMS, but i want to know how that will be used if im using sql server as a back end database for an asp web site, or an application. does the sql server have to be protected with an SSL cert, and once a user has lo
  • The '[CDbl]' function does not exist.
    by Keith Spitz
    10 Replies
    Last post by Keith Spitz
      • I have an MDX query that runs fine on everything except my newest instance of AS 2005. The query is... WITH MEMBER [Measures].[Pct] AS ' CDbl([Measures].[Page Views]) / 100.0 ' SELECT { [Measures].[Page Views], [Measures].[Pct] } ON COLUMNS , LastPeriods( 1, [Time].[Calendar].[Month].&[200701] ) ON ROWS FROM [Web Hit Total] ... and the error is ... The '[C
  • How to acces report of other system from my system.
    by Mahender
    3 Replies
    Last post by Jarret
      • Hi, Im Designed a Webpage .It consosts of a Button, whenever i click on Button report must generated.When the report is in my system report generated successfully.when I try to access a report from other system.I cudnot able to access report.Can any1 hlp me inthis aspect .any procedure in order to access the report of other system.wht shud be url for Reportserverurl and reportpath.In short
  • FTP Connection problem with "The Password was not allowed" error message
    by DarrellMerryweather
    3 Replies
    Last post by DarrellMerryweather
      • Hi I have a simple FTP task that I am trying to connect to an FTP server. I can test the connection fine, however, when I try and execute the package from Visual Studio 2005 I get the "The Password was not allowed" message. I have found some threads that mention setting the protection level on the package to EncryptSensitiveWithPassword, however, I still get the same message appearing
  • Problem with "Transfer SQL Server Objects Task"
    by Kevin Otte567895
    4 Replies
    Last post by michal
      • Hi everyone, I'm currently trying to copy a database from one server to another (both SQL2005) using Business Intelligence Development Studio. I've created an SSIS package. The following parameters are defined: DropObjectsFirst true IncludeExtendedProperties true CopyData true ExistingData Replace CopySchema false UseCollation false IncludeDependentObjects true CopyPrimaryKeys true CopyForeignKeys
  • Problem running SSIS from C# program.
    by agentf1
    5 Replies
    Last post by agentf1
      • I am able to run it from the file system but when I try running it from SQL Server I get an error message that it cannot load package. I am using the following code. Package package = app.LoadFromSqlServer("trans_hist", Properties.Resources.dbServerName, Properties.Resources.userId, Properties.Resources.password, null);
  • Schema use in SQL2005
    by Colm Ryan
    10 Replies
    Last post by Michael Hotek
      • The problem we are having is that we are including components from 3rd parties that are expecting the default behaviour of the EXEC statement within a SP to default the schema correctly according to the invoking user. From what I can see this is not happening in SQL2005. Is this a bug in SQL 2005 or normal behaviour
  • Granting UPDATE for only certain columns in a table
    by DanR1
    14 Replies
    Last post by DanR1
      • I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on c
  • Event ID: 17055
    by Chrisc127
    2 Replies
    Last post by Samcara
      • I am running a WSUS and get this error in my event log. I am running Windows 2000 with SQL 2K SP4. 1827 CREAR/ALTER DATABASE failed because the resulting cumulative database size would exceed you licensed limit of 2048MB per database.
  • Trouble with Pivot Task (multiple problems) - Long
    by Errsomeone
    7 Replies
    Last post by Errsomeone
      • All, I am having difficulty with an SSIS package that is simply to pivot a table, and perform calculations used in reporting. Background: A sample set of data is being tested to pivot for reporting purposes. The sample set of data being used is 2226 rows that will pivot to 6 rows having nearly 400 columns. Problem 1: This all seems quite simple except that when I try to pivot on one set of data it
  • @@Version still shows Service Pack 1
    by axel_2005
    4 Replies
    Last post by axel_2005
      • We just installed the service pack 2 to our server, so I did a select @@version but it's still say Service Pack 1, even though the version number is now 3054. Is that a bug in the service pack Thanks.
  • Linked server SQL 2005 to 2000
    by Kevin6
    2 Replies
    Last post by Arnie Rowland
      • I have something similar... On a SQL 2005 default instance on a box named 'machine1', I define a linked server which points to a SQL 2000 instance also located on 'machine1'. In SSMS, I right-click to use 'add linked server' to add 'machine1\sql2000' (taking the SQL Server radio button as the default). The definition works fine. I then try to use the linked server in a four-part name
  • SQL Questions
    by nwcomer
    6 Replies
    Last post by Louis Davidson
      • Hi All, I was asked couple of questions yesterday and I thought I had to still learn a lot. Questions sound very normal but as for as I am concerned, don't know the answers hence this forum. Please advise. Here the questions asked to me 1) A simple insert into the table (could be from .net application or query analyzer) takes 10 minutes and times out, does not do any thing. What coul
  • Line Chart Color
    by CoderMike
    7 Replies
    Last post by Rev-ßoy
      • Hello, My line chart displays all lines in a single color (the series color). I'd like a single color per item in the series just like the bar chart. Is there a way to change this Or is the only differentiation the markers Michael
  • Im new to using views, and this program they have me working on is using them quite heavily..(cant read from a view)
    by James Harold Hall, Jr.
    3 Replies
    Last post by Arnie Rowland
      • This is my first post, so if i have not posted things in the best manner please lemme know how to be more informative,clear, so that i can learn. So i have made a view with the following command GO /****** Object: View [dbo].[AppraisalView_C] Script Date: 10/11/2007 12:10:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo] .
  • Insert Performance
    by Guinness Tom
    1 Replies
    Last post by João Paulo Figueira
      • Hey, I'm writing an application where I have to perform a lot of inserts/updates on a SQL Server Compact Edt. 3.1 database (up to 50.000 or even 100.000 consecutive inserts). I'm using native C++ and OleDB. I set the command text only once for each table and I increased maximum buffer size (DBPROP_SSCE_MAXBUFFERSIZE). There are also no table indices or foreign keys. The performance is quite well,
  • Cannot see Report Builder in Report Manager
    by SamCosta
    3 Replies
    Last post by Jens K. Suessmeyer
      • Hi Everyone, I recently updated my instance of SQL Server 2005 express to install reporting services. I am able to navigate to the report manager url but the report builder button is missing. Also, when I go to the report manager url, It prompts me for the server's username and password. Does anyone know how I can fix this
  • Update = Delete & Insert?
    by SODAR
    9 Replies
    Last post by SODAR
      • I vaguely recall reading an article that I can no longer find that an update statement is executed as a combination of a Delete and an Insert by SQL server. Does anyone know if this a still a true statement in SQL Server 2005 Thanks, -shl
  • odd issue with NOT IN statement
    by Anonymous566943
    3 Replies
    Last post by Nitin Khurana
      • Some info We recently moved a database to SQL2005 (start of year) a program I wrote is having a small issue(not rejecting unmatched orders) and I narrowed it to one command statement (that I tried directly in the management studio) I have two databases on the server (a live and a test DB) on the test DB (same tables and views as live but the data is a bit different) side there is no
  • Looking for Feedback: Native 64-bit Support in SQL Express
    by Mike Wachal - MSFT
    4 Replies
    Last post by Hector Mike
      • Hi All, I have another set of questions for the group to help guide me in planning future versions of SQL Express, this time related to 64-bit support. Quick History In SQL Server 2005, SQL Express was only released in the 32-bit architecture. We supported installation to x64 computers using the Windows on Windows implementation that allowed the 32-bit program to install on 64