SQL Server

Page 4844




  • Topics
    Replies
    Last post
  • Microsoft search service kills SQL 2000 server
    by LS
    2 Replies
    Last post by LS
      • Hi all, This may be more of a Sharepoint or server question but I thought I would post it here to start off with. I have an installation of SQL 2000 SP4 and sharepoint services 2003 all on one server. For example the SQL 2000 (SP4), sharepoint and its indexes all on the one server (HP G4 DL380). I have installed the index service and the full text services on the SQL server then configured
  • Opening sql files opens new instance of SQL Management Studio
    by David C33304
    1 Replies
    Last post by Paul A. Mestemaker II - MSFT
      • Hi Folks, I'm sure this has been answered before but all my searches for this problem don't find what I need. It's a quirk but driving me nuts. If I have sql management studio open and I view a sql file from Vault, or double-click it in explorer, it always opens a new instance of mgmt studio. I open 5 sql files, 5 instances of mgmt studio. How do I tell my system to reuse mgmt studio to o
  • check if there is an existing SQL server installation
    by reggiepangilinanX
    6 Replies
    Last post by Deepak Rangarajan
      • is there a way to check an SQL Server installation, i want to get the version and what edition the installed sql server is. thanks
  • Precedence Constraints and Sequence Containers
    by SQLIsFun
    2 Replies
    Last post by philcava
      • I have about 12 sequence containers mapped out to execute separately based on a precedence contraint and an expression. These lie at the same level and order in my sequence. Only one of these will execute based on an expression. After any of these executes, I have a consecutive sequence container that I'm attempting to execute. I've set the precedence contraint from all twelve of the prior sequenc
  • Top N Sum and Sum for Others
    by Frank van Zuilen
    4 Replies
    Last post by JessicaM
      • My data source is an AS-cube and I have a dataset like: Category Value A 10 B 10 C 10 D 10 E 10 F 5 When I create a table with a details group on "Category" with the following filter "Sum(Value), Top N,=5" then I see the expected categories : A until E. But the sum in the table footer shows 55 in stead of the expected 50. I know that you can def
  • Identity column value increments by 2 rather than 1 on insert
    by SIS
    3 Replies
    Last post by Remus Rusanu
      • I have an issue with a stored procedure activation on a service broker queue. The activation stored procedure simply RECEIVES the top message and then INSERTs a row into a table with an identity INT column. Each row inserted has the identity column value incremented by 2 rather than 1. Only one row is inserted in the table. If the activation is set to OFF and then manually calling the orig
  • Getting Access Denied To FileName Error When Using the Execute Sql Task (With File Connection) into a Foreach Loop Container.
    by SalilD
    1 Replies
    Last post by Rafael Salas
      • Hi ALL, Getting Access Denied To FileName Error When Using the Execute Sql Task (With File Connection) into a Foreach Loop Container. Please Note : I have a folder containing .sql files. I have to dynamically loop through the files and send them as a File connection Folder to the Execute Sql Task. When I run this Package I am getting the follwoing error : [Execute SQL Task] Error: A
  • Need help with a sp
    by Lobotomybeats
    3 Replies
    Last post by Menthos
      • Hello, I am writing a stored procedure that is supposed to get info out of a table. E.g TABLE FRUITS Id Value1 Value2 1 Apple Banana 1 Apple null 1 grape null 2 Plum Melon 2 Plum null 3 berry null As you see there are six items with three ids but different info. If I select * From fruits WHere id
  • How can I generate INSERT statements from Management Studio
    by MohammedLayes
    5 Replies
    Last post by Andrea Montanari
      • Hello All, How are you guys doing Hope all is well. This is my problem...I accidentally deleted a bunch of my SQL scripts and would like to generate the INSERT statements from Management Studio. I am currently using SQLExpress. Is there a way I can accomprish my task Kindly advise. Thanks a bunch! Mohammed
  • how to design database for chinese and japanese characters
    by vrkanaka
    2 Replies
    Last post by Caddre
      • I need a small confirmation regarding storing the Chinese and Japanese characters in sql server. Can we store Chinese and Japanese characters on a same database with Chinese Collation Or else we need to store it separately with respective collations. I tried to store both characters on db with Chinese collation it works but I am not so sure if it is right way to do so. Please confirm on this
  • Get the error in dos cmd line
    by celobateira
    3 Replies
    Last post by celobateira
      • Hi everyone, I have a cmd file that executes sql statements: something like this: Code Snippet OSQL -S %sqlServer% -E -b -n -i DATABASE.sql" IF ERRORLEVEL 1 GOTO error echo - ... :error @ECHO An error occured in [%errorLevel%] echo [%errorLevel%] > %1 GOTO EXIT if there is an error, I print the errorlevel in a txt file wich is a parameter in the command (%1)
  • SQL Server roles & ASP.NET 2.0 Forms Authentication Roles
    by Mark Delderfield
    1 Replies
    Last post by Buck Woody - MSFT
      • Apologies if my post does not fit into this forum. I initially tried the SQL Server Data Access forum but I now think my question is more security related. Is it possible for a web user who has been successfully authenticated with forms authentication to be authorised to use a SQL Server 2000 role depending on a particular ASP.NET 2.0 role that they have been authorised to use I understand that
  • Data-Driven Subscription to Excel with labeled worksheets Question
    by BrandonR
    3 Replies
    Last post by BrandonR
      • I've created a data-driven subscription that works great and delivers an Excel file to a share. The SSRS report contains several reports/tables on one page and when displayed to Excel it creates separate tabs due to the page breaks, which is wanted. Is it possible to provide a name to each of the tabs/worksheets that are created in the Excel file By default, Excel will name them as Sheet
  • SSAS Best Practice
    by Lonnie S
    11 Replies
    Last post by Zach84
      • My team has been presented with the question: Is it better to use another layer between an Analysis Services data cube and the presentation of it or not It would seem to me that if the pure goal is performance, then the least amount of moving parts the better, and leave the multi-tier structures for other parts of the application. What are TechNets thoughts on this and/or best
  • distribution cleanup cannot clean up snapshot folder
    by danser67
    2 Replies
    Last post by danser67
      • We are using SQL Server 2005 SP2 to do transactional replication. We and have a separate service account for the SQL Agents (sqladmin) vs. SQL Replication Agents (sql rep admin). It is my understanding this is a replication security best practice. The sql rep admin has full permissions on the snapshot share folder and it's subdirectories. The sqladmin account does not have permissions a
  • define/set parameter values in Management Studio?
    by tee_user5
    1 Replies
    Last post by Dave Fackler
      • If you have a query w/ a parameter in it (copied from reporting services, but now working with management studio), how do you declare the parameter and set its value in sql server management studio I've had to unfortunately find all occurrences of the parameters and replace their values each time I want to change them when executing the mdx.
  • Best practices - currency elements
    by JRStern
    3 Replies
    Last post by Kent Waldrop Au07
      • Hello! I'm a long-time SQLServer developer, but new to XML. I find myself doing some XML related to EDI messages. When you have a field containing a dollar amount, what format should you use in the XSD We've been using decimal. But that's just half the question! When the XML comes in and there is a round dollar amount, we've been getting the data in integer forma
  • SQL Command Datareader
    by John Smith001
    9 Replies
    Last post by Rafael Salas
      • I have the following SQL statement in the DataReader.SQLCommand. select * from myTable where DataEdited > 'some hard coded date data' I want to read the above 'some hard coded date data' from a table sitting in different database which is not the same server where the DataReader is connected. How to do that I can populate the 'some hard coded date data' to a SSIS variabl
  • suser_sid returns value for nonexistent login
    by postwick
    5 Replies
    Last post by mfrei99
      • I have code that runs suser_sid and if it is null it creates a login, then uses sp_adduser to add that login to the database. If suser_sid is not null then it just runs sp_adduser. Well, suser_sid(N'COMMERCIAL DIRECT') returns a value, even though there is no login named COMMERCIAL DIRECT. Then when sp_adduser tries to run, I get an error "is not a valid login or you do not have permission&qu
  • Count the occurance of a character in a string
    by shax
    4 Replies
    Last post by Chris Howarth
      • Hi, can anyone tell me how to count the occurance of a character wihtin a string e.g. if the string were 'abcdeaaa' how would you count the occurances of 'a' i.e. 4 for the given string hope you can help cheers
  • What technique to use to update production table from staging table
    by Mr Pro Tools
    9 Replies
    Last post by Phil Brammer
      • Hi I have a production table in SQL Server 2005 that has approx 500,000 records---every 6 hours this table needs to be truncated and filled The basic SSIS package uses a script compentant and imports the data into a staging table which has the same structure as the production table. I have a final Execute SQL Task that Truncates the production table and does a Insert into production-select * fr
  • truncation error message
    by CSharpCoder
    14 Replies
    Last post by Phil Brammer
      • Ok, this is starting to drive me nuts, I've been trying to get this to work for 2 days now. I have a .csv file that I'm reading and importing the data into my table. I defined Derived columns for the type and the lengths as well. I have one column that keeps kicking out this error: The column in the db has a length of 50, the column in my derived column is set to 50, now there are some strings in
  • Error in executing stored proceduNot a valid identifier
    by Kusuma585539
    8 Replies
    Last post by Kusuma
      • Hey I have written the following the stored procedure and executed it.But i am getting the following error. I don't know the reason for this. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go Create PROCEDURE [dbo] . [GSU_Site_ReterieveActiveSitesOnSearch] @whereClause nvarchar(2000) AS BEGIN -- SET NOCOUNT ON added to prevent extra result set
  • OWC scans all partitions (SSAS 2005)
    by NilgunCelikok
    1 Replies
    Last post by Christopher Webb
      • Hello, I have a cube with three partitions. Each partition holds data for the years 2005,2006 and 2007 respectively. In our web application we are creating OWC Pivot Table and putting "date dimension" in the filter area automatically. Altough only "2007-01-01" is included in filter, when we trace the query from profiler we saw that all partitions are read. Is there anyon
  • SQL Server Mobile
    by Mark Cooray
    2 Replies
    Last post by BrianSquibb
      • Dear All Please advice how I could Make relationships in SQL server Mobile. as the Relationship diagram is not available Thankx