SQL Server

Page 4868




  • Topics
    Replies
    Last post
  • Creating an Windows Rdl on the fly using .net programming
    by p4Pratik
    28 Replies
    Last post by p4Pratik
      • Hi, I would like to know that can I create an .rdl file programmatically based on the user selection (USING .Net programming) . Please help with some link / examples. P.S: I am giving very less number of static reports to the client. I want to give a more of a dynamic report , wherein in each case, I will give the user a selection criteria to select the fields fro
  • Datamigration to MS CRM
    by Smilebey
    28 Replies
    Last post by Smilebey
      • Hi all, I have some questions responding to Datamigration to MSCRM. Does someone have experience with that procedure My question is related especially to the SSIS. Thx
  • SQL server replication connection problem
    by danrostron
    3 Replies
    Last post by Greg Y
      • Hi I have a problem when trying to setup replication between two SQL servers on different networks. My publication server is SQL Server 2005 Standard Edition. My subscription server is SQL server 2005 Express Edition I have setup the publication no problem but am now trying to create my subscriber. However, when trying to connect to the server, I receive the following error
  • Aggregation Types
    by Shyam Sundar
    2 Replies
    Last post by Shyam Sundar
      • Can anyone briefly describe all aggregation types available in SQL Server Analysis Services Thanks, Shyam
  • the procedure 'sp_addrolemember' cannot be executed within a transaction
    by msaeida
    1 Replies
    Last post by Raul Garcia - MS
      • I use sp_addrolemember inside a DML trigger and every thing goes well in my computer; I can insert or update into my table and sp_addrolemember is executed successfully, but my customer get this error every time he tries to insert or update into the table. "the procedure 'sp_addrolemember' cannot be executed within a transaction" Can anybody help me solve this funny error.
  • Get Culture for Multilanguage in Reporting Service
    by annefa
    7 Replies
    Last post by annefa
      • Hi.. I have a windows application that can change the language of the application depends on the language preference of the user. My application can switch between chinese(zh-CHS) and english(en-US). I also have a report that also can change the language (hopefully) if user change their language preference in the framework of my application. I already follow the step provided in this
  • using case statement to determine Order by field and direction (asc or desc) when using Row_number
    by smithalovesdotnet
    6 Replies
    Last post by Manivannan.D.Sekaran
      • I am trying to order by the field and direction as provided by input parameters @COLTOSORTBY and @DIR while using a CTE and assigning Row_Number, but am running into syntax errors. Say I have a table called myTable with columns col1,col2,col3, Here's what I'm trying to do with myCTE AS ( Select col1 ,col2 ,col3 ,row_number() over (order by case when(@DIR
  • Reporting Services 2005 with SQL 2000 Database
    by eriveraa
    2 Replies
    Last post by Caddre
      • Hi friends, i have some questions about Reporting Services 2005: Can i use RS 2005 with a SQL 2000 Database Can i create a report with RS 2005 (with a SQL 2K Database) a show it in a webform What do i need to install (in the webserver and in the Database server) in order to start designing reports in RS 2005 against a SQL 2K DB Thanks in advance. Regards Eduardo
  • Deleting data bloats log file
    by Moonshadow
    11 Replies
    Last post by Moonshadow
      • When I delete substantial amounts of data using the SQL DELETE command, the database size apparently remains the same (702 mb) and the log file goes from about 17 mb to over 1 gig. I was expecting for the overall size to decrease drastically, but got just the opposite. Is this typical Can I do something to slim it down As I am just trying to decrease the overall size to make it easier to work w
  • Could not find "Standby" in sysservers. Run "sp_addlinkedserver" to add the server to sysservers"
    by pinocchio
    5 Replies
    Last post by oj
      • a different scenario leads to the same problem, the error message: Could not find "Standby" in sysservers. Run "sp_addlinkedserver" to add the server to sysservers" I browsed the thread for the same error message and the solution doesn't applies to me. Here is my system settings. we have a kind of backup system. a primary server is set up to copy the database files to a
  • running ssis package with ssis run time compoenents and sql server 2000...
    by spattewar
    1 Replies
    Last post by Jamie Thomson
      • Hi Jamie, thanks. I have similar concerns. Do you have any links or infromation pages that we can read through and provide it to our DBAs. Thanks, $wapnil
  • export table to excel
    by wraithzshadow
    10 Replies
    Last post by OdieDenCO
      • how should I go about exporting a couple of columns of data from a specific database table to an excel spreadsheet stored locally on a client machine (the one the script is being executed from). I am using SQL server 2000 SP3. I'm fairly new to using SQL server, and not experienced at all with Transact-SQL.
  • CTE behaviour in SQL 2005
    by Gertus
    1 Replies
    Last post by Nick V.
      • I were trying to achive paging through using a CTE etc, but ran into the following weither thing happening. The CTE allows me to use avariable as the ORder By field, although the CTE do not care at all what is in there Have any one seen this or maybe can explain this USE AdventureWorks ; GO DECLARE @SortExpression Varchar ( 50 ) Set @SortExpression = 'Sal
  • Dynamically determine Linked Servers
    by Nate Garvey
    6 Replies
    Last post by Arnie Rowland
      • In our system, we need to execute queries using linked servers. However, the linked server name is not well known, it is a value stored in the system. Is there a way this can be done CREATE FUNCTION dbo . stfGetSupervisorOrgUnitAssignments ( @SupervisorID INT ) RETURNS @ReturnTable TABLE ( Org_Unit INT PRIMARY KEY ) AS BEGIN DECLARE @Server VARCHAR ( 100
  • SQL Problems
    by shacky
    9 Replies
    Last post by shacky
      • 1. now i'm using bulk insert command to read sales data form text file into posmaster table in databases. the problem is this bulk command only read from single text file. what command should i use if i want to read sales data from multiple text file. this is the sample of bulk insert command for single text file. BULK INSERT posmaster FROM 'c:\SALE\010407_S13101.txt' WITH ( FIRSTROW =1, FIELDTERM
  • Multiple web viewers and AsyncRendering true
    by phuhn
    1 Replies
    Last post by phuhn
      • I have multiple viewers on a web page and initialy would like AsyncRendering = true on all viewers, so I can have the loading message. Once the user drill-through, I hide all other viewers and change to AsyncRendering = false, so the autosizing will work. But, with AsyncRendering = true (in code behind): private void SetDominateViewerProperties(ReportViewer rptViewer) { rptViewer.Asy
  • UnknownSqlServerError
    by jterlouw
    6 Replies
    Last post by jterlouw
      • Hi guys, I have a problem to have my webservice get to work. I exec this very simple: DROP ENDPOINT sql_endpoint ; GO CREATE ENDPOINT sql_endpoint STATE = STARTED AS HTTP ( PATH = '/sql' , AUTHENTICATION = ( INTEGRATED ), PORTS = ( CLEAR ), SITE = 'SQL' ) FOR SOAP ( WEBMETHOD 'GetSqlInfo' (
  • SQL Server 2005 Express Edition with Advanced Services Service Pack 2 - Error 65B
    by Soulia
    14 Replies
    Last post by jona.than
      • Hi - Who else had received this error during Windows update I'm running Vista ultimate. There are a couple of posts on google, but no solutions yet.
  • ssis cannot pull columns from stored procedure?
    by CraigL77
    3 Replies
    Last post by jwelch
      • hi, i have the following stored proc which returns a resultset at the end, i have an SSIS package that calls this stored proc and outputs the result to a file. However, the package fails because it cannot pull the columns for the schema because of the return lines in the middle of the stored proc. If i remove the it works fine, pulls hte columns as normal. but if i leave them in ssis cannot
  • Problem with function
    by Nilkanth
    3 Replies
    Last post by GDR
      • Hello, I am unable to resolve an error message for following user defined function. Scope of this function: This functions generates a unique identifier no from a table and returns it to caller. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION SystemNoShiva1 ( -- Add the parameters for the function here ) RETURNS int AS begin DECLARE @st2 n
  • Aggregation Wizard Question
    by BrianMarshall
    7 Replies
    Last post by BrianMarshall
      • Does the aggregation wizard have issues with a large number of dimensions Adding one more dimension to my cube (the dimension added only has 64 members, Key and All levels only, both with aggregationusage set to Unrestricted) causes the aggregation wizard to stop designing at 14 aggregations instead of the original 155 before adding the dimension.
  • How to automatic update view when table's structure has changed
    by jeRKer
    6 Replies
    Last post by jeRKer
      • For example: Create view View_AutoUpdate as ( select a.*,b.[name] from User as a,Company as b where a.CompanyID=b.CompanyID ) Done,but when i do it follow: Alter table User add UserAddress nvarchar(50) null Done. finally,i type "select * from View_AutoUpdate ",the list column is not right. thanks
  • Purging data off of an MSDE database.
    by Travis H
    5 Replies
    Last post by Jens K. Suessmeyer
      • How do I purge data off of an MSDE database. I only want to keep 6 months of data in the database. Right now I have data going back to 2004. I get errors about every 10 seconds. "Primary File Group is Full" is the error I am getting.
  • SQL Problems
    by shacky
    9 Replies
    Last post by shacky
      • 1. now i'm using bulk insert command to read sales data form text file into posmaster table in databases. the problem is this bulk command only read from single text file. what command should i use if i want to read sales data from multiple text file. this is the sample of bulk insert command for single text file. BULK INSERT posmaster FROM 'c:\SALE\010407_S13101.txt' WITH ( FIRSTROW =1, FIELDTERM
  • to archive content of a table frequently
    by Babak1
    3 Replies
    Last post by Rafael Salas
      • Hi , In a project with SQL Servcer 2005 the customer is interested to save ( archive ) content of a table frequently. They want to have possibility to restore the table content as before. I have suggested to export the table every day to a text file and save the file in Visual source safe. If they need there will be possibility to import the text file later. Now I wonder, is there any o