SQL Server

Page 4813




  • Topics
    Replies
    Last post
  • Filter multivalue DateTime parameter
    by Nirmal Azhagarselvam
    5 Replies
    Last post by Shyam Sundar
      • Hi all, I am using stored procedure dataset. i tried filtering the dataset values with the parameter of type datetime.I am able to view and select multiple datetime value from the list. but its not filtering the values . i changed the parameter datatype to string but it works only for the first value (parameter. <pname>.value(0)). if i filter with the array value (parameter. <
  • Login failed for user '(null)'
    by Santhosh Pallikara
    4 Replies
    Last post by Hemantgiri S. Goswami
      • Hi, I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000. Description: 18452: Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection. When I user SA, I do not get the above error. Any clari
  • Is it possible to export a database model from visio to Sql Server 2005?
    by vbjunkie
    4 Replies
    Last post by Jens K. Suessmeyer
      • Hi there, I cannot seem to find a way to export a database model from Visio to Sql Server. Can somebody provide a walkthrough how to export it Thanks a lot
  • Configuration Order
    by Philip Coupar
    9 Replies
    Last post by Scott Nicholls
      • I am trying to use the SQL Agent to specify the connection properties of the connection manager that supports all of the other SQL Configurations in my packages. It would appear that configuration files specified in the SQL agent job are applied after the other configurations. I have the same package I want to use under different configurations on the same machine. This package is also portable
  • scheduled task not running
    by b00gieman
    4 Replies
    Last post by dyarwood
      • Hi! I've written an scheduled job for importing an excel file into a sql table.When I try to run the job from Sql server agent , I get the status 'Not running',and in the last run status,it's written 'failed'.I've tested the command before in the query analyzer,and it works.Can someone tell me why isn't this working as a scheduled job Thanks in advance!
  • How do it right?
    by bonza
    2 Replies
    Last post by GMan2
      • I try to do conversation sending without any errors.And with clean sys.conversation_endpoints. There is my activation procedure code: Code Snippet SET NOCOUNT ON DECLARE @ConversationHandle UNIQUEIDENTIFIER DECLARE @ConversationGroupID UNIQUEIDENTIFIER DECLARE @MessageType NVARCHAR ( 126 ) DECLARE @Message VARBINARY ( MAX ) DECLARE @MessageXML XML ;
  • tabel scan
    by shamen
    3 Replies
    Last post by Adam Tappis - IMGroup
      • Hi All, When an end user view a report using report manager or a custom build web site, would query of the report scan the tables in original data base In this case it is a OLTP data base. Thanks
  • Cannot Load SQLSpars.dll
    by Jon500
    14 Replies
    Last post by Jon500
      • Hello, I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one: Setup Failed: Could not load SQLSpars.dll Why would this happen I see this message after beginning the SQL Server 2005 Standard setup and making my installation selections and beginning the install. The
  • Strange thing in All examples at MSDN
    by prashant_victory
    2 Replies
    Last post by Vijay Ram S
      • Hi, I have seen many examples at MSDN library related to SQL Querries in all queries one thing is same the way they use tables in there queries. BUT wht is this really i am not getting this, can anyone tell me.. the code and the problem is as follows: Code Snippet FROM Purchasing.ProductVendor JOIN Purchasing.Vendor ON (ProductVendor.VendorID = Vendor.VendorID) In the above code u see &quo
  • SQL server database services option greyed out
    by brindleoak
    4 Replies
    Last post by Vidhya Sagar
      • Hi, I'm trying to install SQL Server 2005 onto my XP Professional PC. When I get to the "Components to install" part, the "SQL server database services option" is greyed out. Infact, all options except "Workstation components..." are greyed out. I've tried uninstalling all previous versions of SQL server and trying again, but with the same results. any h
  • Where do I buy SQL Server Management Studio?
    by Jeffery Cotton
    6 Replies
    Last post by Caddre
      • I have the Express version but now need the full tool set. I've been looking for the last half hour on Microsoft.com and elsewhere, and can find absolutely anything I could want to know about the program except how to purchase it. I feel kind of stupid, but I have to ask: where the hell do you buy this thing :-) Thanks. Jeff
  • Sorting a table with numbers and letters
    by Selectis
    3 Replies
    Last post by Selectis
      • I have a field (varchar) in a list that contains numbers and letters. I want to sort this table but I have only two functions that will work to convert the values: Val The Val function sorts the numbers in the string, but the letters are not sorted CStr The CStr function sorts the letters, but the numbers are not sorted How can I sort the numbers and letters
  • Error with SMO.TransferData() (Exception from HRESULT: 0xC0011008)
    by ALight
    11 Replies
    Last post by ALight
      • OK, I have tried just about everything over the past 9 hours. I think I've read through every forum regarding anything similar to errors with SMO and TransferData(). However, I still can't fix my problem. What I'm trying to accomplish is a workaround for deploying my database application using ClickOnce. Since I can't include the database when upgrading (which would wipe out users' d
  • Can't uninstall SQL Server 2005 or install .NET 3.0 64bit after installing Office 2007
    by SoQL
    0 Replies
    Last post by SoQL
      • Well I had no response on the 64bit NET forum so I am posting here !! Windows Automatic Update has just failed to install .NET 3.0 (x64) WAU decided for itself that I needed this update Add Remove Programs reports the following (x64) programs ... .NET Framework 2.0 .NET Framework 2.0 SDK MS SQL SERVER 2005 VS2005 64bit prerequisites VS2005 64bit Remote Debugger MSinfo32 reports OS Name Microsoft(R
  • Whats the different between SQL Express & SQL Server 2005?
    by HSBF Lewe
    2 Replies
    Last post by HSBF Lewe
      • Hi, I'm working in a small company (less than 30 user), we can't buy MSSql Server 2005: Q1: can we use the Express edtion do access our data I mean for commersial purpose.. Q2: dose the Express edition stand to (30 connection) at the same time Q3: can I add users to it    
  • SQL Server Management Studio Express on Vista Home Premium (Error on attaching and detaching .mdf)
    by Glen Satuito
    6 Replies
    Last post by Glen Satuito
      • I have SQL Express 2005 SP2 installed in my Vista Home Premium. I am using SQL Server Management Studio Express to manage .mdf. When I click "Add..." to attach .mdf database, I have this prompt error message : The server principal "My-PC\MyName" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error:
  • SUM returns incorrect value in SQL Server Mobile Query ... Bug??
    by AussieNoobie
    12 Replies
    Last post by Pragya MSFT
      • Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.Order
  • Blocking in Analysis Services
    by ICLTD
    1 Replies
    Last post by Phil Brammer
      • We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyo
  • converting varchar to int
    by raj416
    6 Replies
    Last post by raj416
      • Syntax error converting the varchar value '3.1.7.4.3.9.' to a column of data type int... how to overcome this problem ..
  • Error - The report server cannot decrypt the symmetric key?
    by Job Lot
    5 Replies
    Last post by Teo Lachev
      • SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more informati
  • need to determine which db is pricipal
    by Ofirb
    3 Replies
    Last post by Deepak Rangarajan
      • Hi All, i am working with database mirroring and i need to be able to determine which database will be principal. for example if server A is principle and server B is mirrored and server A is down, then server B take owner and become principle, after fixing server A i want it to be principle again, is it possible
  • Different ways to set DATEFIRST
    by Ponnurangam
    3 Replies
    Last post by Arnie Rowland
      • Hi All, My week starts on Monday rather than on Sunday which is default(US, English) in SQL Server and would like to change the same so I would get proper weeknumber and dayindex using DATEPART. I am looking at different ways of setting DATEFIRST(SET DATEFIRST 1) in SQL Server 2005. I could set in a stored procedure, but this isn't a feasible way for me because I am using .net
  • custom url not recognized
    by Jnash
    1 Replies
    Last post by Jnash
      • i have this action.jumpto url = "javascript:void window.open('http://bklc-crm01:5555/cs/cases/edit.aspx id={" & cstr(Fields!incidentid.Value) & "}','_self')" for some reason when i use this field (incidentid.value) there is no hyperlink generated, however when i change the value to another field, the hyperlink works, what shall i be looking for, inci
  • Only able to access Report Manager as Administrator
    by Hangleton
    6 Replies
    Last post by windthorstking
      • Hi, I have Reporting Services set up with the permissions (via Right Click Server/Permisions in SSMS or System Role Assignments in Report Manager) set as follows: BUILTIN\Administrators - System Administrator When logged in as an administrator I am able to access Report Manager, no problem. However, I want to add a new group so that non-administrators can access Report
  • SQL Agent Roles
    by Michelle A.
    14 Replies
    Last post by Michelle A.
      • I have a domain account that is assigned the the SQLAgentOperator, SQLAgentReader, and SQLAgentUser roles. That domain account is able to create a job and delete the job. But, it is unable to edit the job. If I create a SQL Login with these same permissions, it is able to edit the job. What am I missing We were looking forward to implementing these new built-in security roles because we