How to set the current connectionString user as a defualt value?

Getting started with SQL Server

Index ‹ SQL Server

- Previous
  - 1
    - OLE DB Source to Flat File Destintation using Fixed Width Columns - determining source column width Hi, I am trying to create a program that transfers tables to flat files. At this point in time, I have suceeded in created one that creates delimited files. However, I am now trying to create fixed-width files as you can do with the SSIS designer, but programatically. Is there a way to programatically determine the width of a column from the source table I can not seem to find any kind of function or member that stores this information or allows me to retrieve it. I know what I need to change in order to set a width for a column, but I just don't know how to find the width without just asking the user to provide one. Tag: How to set the current connectionString user as a defualt value?
  - 2
    - date picker format In IE but I think you said you already checked this: IE: tools - options - general - [languages...] - There may be something else to check, if the above doesn't work let me know and I'll try and find out Tag: How to set the current connectionString user as a defualt value?
  - 3
    - Data disappearing during Run time Hi J_Dude, Sorry, could interpret a type in your last response... J_Dude2003 wrote: however if I close the application and re open it the data that I'd previously saved is nw there Is that "nw" supposed to be now or not Could you also clarify a couple points Are you using a User Instance (i.e. your database is embedded in your application project) or a connection to the main instance with an attached database Is this problem happening when you're debugging your application or when running a deployed copy Thanks, MIke Tag: How to set the current connectionString user as a defualt value?
  - 4
    - Old problem, but... Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. I didn't use SQL Express before, now I am trying to use it. I thinkk it is convinient if you just want to copy db files to user's machine. like this <add name="schsecurity" connectionString="Data Source=.\SQLExpress;Integrated Security=true;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" /> as long as user has sql express installed, he should be able to use the db once he copy the file aspnetdb.mdf over. but when I tried it, I got Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. it looks simple, SQL express can not verify user 'NT AUTHORITY\NETWORK SERVICE' so I connect SQL express with SQL server management studio, and add the user into login of the SQL express and set the user as sysadmin. But I still get the error. Any idea thanks! Tag: How to set the current connectionString user as a defualt value?
  - 5
    - Data Conversion Its a lot of fields 300... but doing something flexible as you described I dont know without using code... In your case I would convert the data directly in the SQL query using CONVERT or using the convertion transform of SSIS... regards! Tag: How to set the current connectionString user as a defualt value?
  - 6
    - Results from Aggregate() are wrong The measure I am using is just a simple base measure, not a calculation. CurrentMember doesn't become a concern in this example unless the CurrentMember of [Product].[Product Indexing] is being thrown off for some internal reason. The Product Species hierarchy is unnatural with two attributes. The Product Indexing hierarchy is natural with two different attributes. As I understand this, the slicer (multiselect on the second level of Product Species) is somehow throwing off the Product Indexing hierarchy which is used on rows. Attributes in Product Species are not related to attributes in Product Indexing - unless you go all the way back to the dimension key attribute which is not present in either hierarchy. I've spent quite a lot of time attempting to reproduce this in AdventureWorks but am not able to since I can't find a meaningful pattern behind the problem in my own cubes. I will open a support case and see if I can get somebody to look behind the curtain. Thanks, David Tag: How to set the current connectionString user as a defualt value?
  - 7
    - Inconsistent Linked Server Query Results Hello, I have a linked server named 'Charlie_File' to an Excel Workbook that I set up in SQLServer 2005 Management Studio. The workbook is on my local C drive. Sometimes, I get the results back that I expect when I run the following query; SELECT * FROM OPENQUERY ( Charlie_file , 'SELECT * FROM [Feb$]' ) Sometimes, on subsequent runs of the above query, I get the following message; Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "Charlie_file" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "Charlie_file". There seems to be about a minute or so of a delay before the query will run correctly on subsequent attempts. Is there a connection issue here where a connection blocks subsequent attempts to select the data within a specific time span Thank you for your help! cdun2 Tag: How to set the current connectionString user as a defualt value?
  - 8
    - Can't get Dynamic Security working ... My filter expression in the AllowedSet is different for each level of the hierarchy. For DDO, it's: FILTER([DynManager].[DDO].Members, INSTR([DynManager].[DynManager].CurrentMember.Properties("DDO Access List"), "JJester")) For ROM, it's: FILTER([DynManager].[ROM].Members, INSTR([DynManager].[DynManager].CurrentMember.Properties("ROM Access List"), "JJester")) For RVP it's: FILTER([DynManager].[RVP].Members, INSTR([DynManager].[DynManager].CurrentMember.Properties("RVP Access List"), "JJester")) and on and on .... Do you have any idea why my test query would work in SQL Server Management Studio, but then I get the "more than one hierarchy" error when I try to apply the same FILTER expression in the AllowedSet Tag: How to set the current connectionString user as a defualt value?
  - 9
    - Sql Query to create nested XML Sitemap Hi Kent, I had gone through that post earlier and I think that it is different from what I want to achieve. The database contains all the details for a sitemap (such as Url, Title, Description and Roles) and the XML file which I have to generate using sql query is the Site Map file which is used in asp.net to implement the site navigation features on a website. Hope that helps!! Tag: How to set the current connectionString user as a defualt value?
  - 10
    - How Extract the data of TFINF when doing text mining? Thanks How Extract the data of TFINF when doing text mining Thanks Tag: How to set the current connectionString user as a defualt value?
  - 11
    - Passing SELECT ALL from URL OK, Here is the code for the 2 functions. one is SQL the other is CLR. You do not have to use CLR, there are multiple other ways to do this. See http://www.sqlservercentral.com/forums/shwmessage.aspx forumid=399&messageid=386759 Also, note that the CLR I show here is limited to 4000 chars and miss a build-in LTRIM... Count chars Code Snippet CREATE FUNCTION dbo . fn_countchar ( @source varchar ( max ), @charval varchar ( 255 )) returns int as BEGIN DECLARE @len int , @icount int , @count int SET @len = len ( @source ) SET @icount = 1 SET @count = 0 WHILE @icount <= @len BEGIN IF substring ( @source , @icount , 1 ) = @charval SET @count = @count + 1 SET @icount = @icount + 1 END RETURN @count end Split multi-param Code Snippet using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server. SqlFunction (IsDeterministic = true , IsPrecise = true , TableDefinition = "SQLStr nvarchar(4000)" , FillRowMethodName = "FillSplitCommaDelimitedStringToStr" )] public static System.Collections. IEnumerable clrfn_SplitCommaDelimitedString( SqlString str) { string x = str.Value; if (! string .IsNullOrEmpty(x)) { return x.Split( ',' ); } else { return null ; } } private static void FillSplitCommaDelimitedStringToStr( object obj, out SqlString str) { if (obj != null ) str = ( String )(obj); else str = String .Empty; } }; Tag: How to set the current connectionString user as a defualt value?
  - 12
    - configure sql xml support IIS Hope someone can help me...anything would be appreciated. I am using sql server 2000...When I open the Configure sql xml support IIS tool to create a Virtual Directory the only thing that shows up is a computer icon and a IIS Virtual Directory Management for SQL Server. I can't expand ... there isn't a default web site. The other tool called Enterprise Manager works fine with XP. Matter of fact all of the other tools work except for the Virtual Directory Manager. Tag: How to set the current connectionString user as a defualt value?
  - 13
    - Clone new database from existing All I got was some meaningless generic "operation failed" type of error, plus, the odd behavior I described above when sanitizing (running update queries against) the cloned database. I did try restoring the source db and specifying clone db as target, but was prevented from doing so with a message to the effect of "target database not in dataset so not allowable." If somebody wouldn't mind trying to clone a db from the same server through Sql Express Manager, and let me know the results, I'd feel better about trying it again. When I tried it, I discovered I was simultaneously sanitizing both databases. Rick Tag: How to set the current connectionString user as a defualt value?
  - 14
    - How to restrict a custom component to be used only in the event handler tab? UITypeEditor and usage is fully documented as part of the .Net framework. Even if you have not installed the .Net help, the MSDN site has it all for free. You should read up on the PropertyGrid control and see what options you have. A TypeConverter may do. Try these to start with http://msdn2.microsoft.com/en-us/library/aa302326.aspx http://msdn2.microsoft.com/en-us/library/ayybcxe5(VS.71).aspx http://msdn2.microsoft.com/en-us/library/53c49eck(VS.71).aspx Tag: How to set the current connectionString user as a defualt value?
  - 15
    - catch me if you can / bug in the "bug"? 1. Well actually it does, it states that compilation errors are not caught at all. Like "SELEKT *" (which has a typo and a incomplete syntax) 2. Well, its documented :-) Hey, wait a minute, this is a feature :-) 3.Well it won’t as it would break users code. Tag: How to set the current connectionString user as a defualt value?
  - 16
    - Parameters in an OLE DB Command Hello! Is there a way to use an OLE DB Command transform to execute the following SQL query "Select sum(length(" + @[User::varDBName] + ":informix.cyh_t.u_obj)) from " + @[User::varDBName] + ":informix.cyh_t, " + @[User::varDBName] + ":informix.cch_t where " + @[User::varDBName] + ":informix.cch_t.d_obj = {D '" + @[User::strQueryDate] + "'} and " + @[User::varDBName] + ":informix.cch_t.n_objid = " + @[User::varDBName] + ":informix.cyh_t.n_objid" I get a DB number from an OLE DB Source, do a lookup to get the DB name and then I want to use the OLE DB command to get a result from the query but I can't seem to get this to work. Am I using the wrong transform Thanks. Tag: How to set the current connectionString user as a defualt value?
- Next
  - 1
    - Generating letters in SSRS Hi. I'm looking for tutorials on how to use SSRS 2005 to generate letters in Word or PDF format from a database. We need to send letters with our company logo and some boilerplate text to a set of companies based on a SQL Server query. So the letter will look something like this, with the red areas repeating from the dataset, [logo goes here] 123 Any St. AnyCity, CA 90210 [today's date] Dear [name from database] , Some boilerplate text goes here. Your Account [account number from database] is past due. Sincerely, [scanned signature goes here] Somebody Tag: How to set the current connectionString user as a defualt value?
  - 2
    - Can I retrieve a result set from a sp into a variable within a Execute SQL Task? What *exactly* do you have entered in the SQLStatement box Tag: How to set the current connectionString user as a defualt value?
  - 3
    - Creating Stored Procedure in SQLServer2005 Are you getting the point to where you see something like this: Code Snippet -- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName> -- Add the parameters for the stored procedure here <@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>, <@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0> AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2> END GO Tag: How to set the current connectionString user as a defualt value?
  - 4
    - Help with modifying a data source's query at runtime Please help figure out what is wrong with my code. The script is supposed to load a package (from file). The loaded package already has everything set up to run a query against a local server and output the results to an Excel file. The reason for the outer script is because I need to change the query based on a global variable. When the query changes, though, I think the existing dataflow Path is no longer valid, so I should remove it and re-create another one with the new input mappings. Here is my code, which runs and throws an exception at the AcquireConnections call. The error is Error: 0x2 at Script Task: The script threw an exception: Exception from HRESULT: 0xC020801B I pieced together this code from the examples in the online books, but I am not sure what to do. ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Public Class ScriptMain Public Sub Main() ' Dim app As Microsoft.SqlServer.Dts.Runtime.Application = New Application() Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _ app.LoadPackage( "c:\systime\ExcelOut\ExcelOut\ExcelOutDo.dtsx" , Nothing ) Dim pkgVars As Variables = package.Variables Dim gsVar As Variable = pkgVars( "User::gsExcelFile" ) Dim currVars As Variables = Dts.Variables Console.WriteLine(Dts.Variables( "User::gsExcelFile" ).Value) gsVar.Value = Dts.Variables( "User::gsExcelFile" ).Value pkgVars( "User::gsQuery" ).Value = Dts.Variables( "User::gsQuery" ).Value pkgVars( "User::gsCreateTable" ).Value = Dts.Variables( "User::gsCreateTable" ).Value Dim e As Executable = package.Executables( "ExcelOutTask" ) Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType (e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataFlowTask As MainPipe = CType (thMainPipe.InnerObject, MainPipe) ' Get the source component. Dim SourceComponent As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Local Source" ) Dim srcDesignTime As CManagedComponentWrapper = SourceComponent.Instantiate() srcDesignTime.ProvideComponentProperties() ' Reinitialize the metadata. srcDesignTime.AcquireConnections(vbNull) srcDesignTime.ReinitializeMetaData() srcDesignTime.ReleaseConnections() ' Get the destination component. Dim destination As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Excel Destination" ) Dim destDesignTime As CManagedComponentWrapper = destination.Instantiate() destDesignTime.ProvideComponentProperties() ' Create the path. dataFlowTask.PathCollection.RemoveAll() Dim path As IDTSPath90 = dataFlowTask.PathCollection.New() path.AttachPathAndPropagateNotifications(SourceComponent.OutputCollection(0), _ destination.InputCollection(0)) 'Console.WriteLine(dataFlowTask.PathCollection.Count) Dim ret As DTSExecResult ret = package.Execute() Console.WriteLine(ret.ToString) Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: How to set the current connectionString user as a defualt value?
  - 5
    - Two Dimensions Sharing same Parent Table I believe your issue is due to the fact that dimensions are only really "related" to each other via their relationship to a given measure group (fact table). Thus, when you filter on a given company via one dimension but browse the other dimension, you will see all companies because the second dimension's member list cannot be filtered by the first dimension. Now, if you add measures to the pivot table, if you have the pivot table configured to hide empty rows and columns (the default I believe), then the other companies should disappear from the pivot table as there should be no data for a given company (from either dimension) that is not in the filter. Would it be possible for you to break company out into its own dimension so that there is only one list of companies The brand and department dimensions would then start with brand group and department group -- which may not be good given you will see all brand groups (across companies) and department groups (across companies) listed together. Would that be a more confusing situation for the end users Another possibility might be to create a named set in each dimension that only includes groups (brand or department) that are under the current member of the company selected in either of the other dimensions. Just a thought (as I have not tried to mock up anything to try it). HTH, Dave Fackler Tag: How to set the current connectionString user as a defualt value?
  - 6
    - Can't shrink DB I've tried it with all options: DBCC SHRINKFILE (FILE_NAME) also I've tried to set target size, with both notruncate/truncateonly. I didn't get error YP Tag: How to set the current connectionString user as a defualt value?
  - 7
    - Reporting services in SharePoint integration mode problems Hi, I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production. Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message: Code Snippet An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods() at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods() --- End of inner exception stack trace --- I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib. Some info: - SP apppool is running under domain account a - SSRS apppool is running under domain account b - SP uses NTLM authentication - SP and SSRS are running on different servers - SSRS Configuration shows all green checkmarks Things I tried: - Basic authentication instead of Windows Integrated on SSRS - NTLM only instead of Negotiate on SSRS - Settings SPN's for SSRS, didn't help - Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list) Does anyone have an idea about how to solve this Any help is appreciated. Tag: How to set the current connectionString user as a defualt value?
  - 8
    - Recursive Query Without Self-Referencing Structure I need a statement that can return a hierarchy of folders. There are a number of good articles out there describing how to do this in SQL 2005 with a Common Table Expression (CTE) that references itself under a UNION ALL. Yet every example I come across involves a self-referencing table. Unfortunately the architect of my project did not use that simple structure. Instead, we have a Folder table and Folder Properties table. Creating a child Folder involves adding a row in the Properties table that links to a parent. Here's the statement I came up with: WITH Folders (ID, ParentID, FolderName, FolderDepth) AS ( SELECT FOLDER_ID, NULL, FOLDER_NAME, 0 FROM ZZ_FOLDER WHERE FOLDER_ID = 1 UNION ALL SELECT F.FOLDER_ID, Folders.ID, F.FOLDER_NAME, Folders.FolderDepth + 1 FROM ZZ_FOLDER F INNER JOIN ZZ_FOLDER_PROP FP ON FP.FPROP_FOLDER_ID = F.FOLDER_ID WHERE FP.FPROP_LINK_ID = Folders.ID ) SELECT * FROM Folders The initial statement brings back the top of the folder structure. The recursive statement brings back Folder rows that have an entry in their Property rows for the parent. Yet when I try to execute this, I get: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.FolderDepth" could not be bound. It sounds like all the recursive references to the CTE are unavailable. What am I doing wrong Would welcome any suggestions, too. I realize this isn't a T-SQL specific question, more SQL in general, but I didn't see a more relevant forum. What follows are some tables/data to run the above statement against. -- Create Folder Tables CREATE TABLE ZZ_FOLDER ( FOLDER_ID INTEGER NOT NULL PRIMARY KEY, FOLDER_NAME VARCHAR(50)) CREATE TABLE ZZ_FOLDER_PROP ( FPROP_ID INTEGER NOT NULL PRIMARY KEY, FPROP_FOLDER_ID INTEGER NOT NULL, FPROP_LINK_TYPE VARCHAR(50), FPROP_LINK_ID INTEGER NOT NULL) GO -- Populate Folder Tables INSERT INTO ZZ_FOLDER VALUES (1, 'Top Level') INSERT INTO ZZ_FOLDER VALUES (2, 'Second Level A') INSERT INTO ZZ_FOLDER VALUES (3, 'Second Level B') INSERT INTO ZZ_FOLDER VALUES (4, 'Second Level C') INSERT INTO ZZ_FOLDER VALUES (5, 'Third Level A1') INSERT INTO ZZ_FOLDER VALUES (6, 'Third Level A2') INSERT INTO ZZ_FOLDER VALUES (7, 'Third Level A3') INSERT INTO ZZ_FOLDER VALUES (8, 'Third Level B1') INSERT INTO ZZ_FOLDER VALUES (9, 'Third Level C1') INSERT INTO ZZ_FOLDER VALUES (10, 'Third Level C2') INSERT INTO ZZ_FOLDER VALUES (11, 'Fourth Level A3A') INSERT INTO ZZ_FOLDER_PROP VALUES (1, 2, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (2, 3, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (3, 4, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (4, 5, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (5, 6, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (6, 7, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (7, 8, 'Folder', 3) INSERT INTO ZZ_FOLDER_PROP VALUES (8, 9, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (9, 10, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (10, 11, 'Folder', 7) GO /* Top Level Second Level A Third Level A1 Third Level A2 Third Level A3 Fourth Level A3A Second Level B Third Level B1 Second Level C Third Level C1 Third Level C2 */ Tag: How to set the current connectionString user as a defualt value?
  - 9
    - c# reusing parameters I have a select statement which requires numerous parameters. here is a snippet. SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection) my parameters are added as follows. SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50); Att1.Value = Attributes1; cmd.Parameters.Add(Att1); and so on... What I would like to do is be able to remove a parameter and re-run the SELECT statement if the number of entries retrieved is less than 5 (or any number) I tried just having a new Sql command like this. SqlCommand cmd2 = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2, connection) and then did this.. cmd2.Parameters.Add(Att1); but it didn't work. Is there a way to do this so I don't have to keep copying the whole parameter command Thank you in advance for your help. And please be gentle, I'm very new to this. Tag: How to set the current connectionString user as a defualt value?
  - 10
    - allocation problem/disk space disappears when processing cube anyone at MS have an idea when this might be fixed / addressed Tag: How to set the current connectionString user as a defualt value?
  - 11
    - searching a Unicode data within a Image data type For the process of indexing Full Text, the proper word-breaker must be used. You can pick a language of your choice from the dropdown in the window where you configure a FTC. The choices depend on the installed languages on you OS. If you want to add more, see BOL for that. You might want to consider changing the collation, since SQL-server uses that for indexing and searching in text. I'm not sure if there is a collation type for Hindi. And I'm not sure what happens if you combine Hindi and other languages. Tag: How to set the current connectionString user as a defualt value?
  - 12
    - SQL 2005 32-bit vs 64-bit guidance What some good reasons to select 64-bit rather than 32-bit for SQL Server 2005 We are preparing to install a very large SQL Server 2005 cluster. Initially, the primary database is estimated at 1 Terabyte, with 5 more databases that will add up to another Terabyte. After a few years, the estimate jumps up to 20 Terabytes for the largest DB and another 20 for the other five, combined. We've made the assumption that a database this large, with up to 1000 concurrent users, that this is a good candidate for a 64-bit installation. And that we're better off starting out with 64-bit, rather than migrating later. Can someone provide some guidance Tag: How to set the current connectionString user as a defualt value?
  - 13
    - Setting a filter in the SELECT-statement Yep, thats the solution! Thx!! I had tried some options but all the time I forgot the GROUP BY-statement..... :) Tag: How to set the current connectionString user as a defualt value?
  - 14
    - ADO Error: an insufficient number of arguments.... Heres the function i have: Code Block SELECT TOP 100 PERCENT dbo.[Totals].User, dbo.[Totals].[Account Name], dbo.[Totals].Company, dbo.[Totals].Name, dbo.[User].Amount AS [Month Amount], dbo.[User].Profit AS [Month Profit], SUM(dbo.[Totals].[Y Amount]) AS [Y Amount], SUM(dbo.[Totals].[Y Profit]) AS [Y Profit], dbo.[User].Month FROM dbo.[User] RIGHT OUTER JOIN dbo.[Totals] ON dbo.[User].[Account Name] = dbo.[Totals].[Account Name] AND dbo.[User].User = dbo.[Totals].User GROUP BY dbo.[Totals].User, dbo.[Totals].[Account Name], dbo.[Totals].Company, dbo.[Totals].Name, dbo.[User].Amount, dbo.[User].Profit, dbo.[User].Month HAVING (NOT (dbo.[Totals].User = N'Temp')) AND (dbo.[User]. Month = @Month ) ORDER BY dbo.[Totals].User, dbo.[Totals].Company Where it states Month = @Month is where the problem is i think. This Function runs fine as i want it to. But when im in another view that uses this function it get the above error. The only way i dont get the error is when i type in the month then all runs fine - but i would prefer it to ask me what month i need the data for Thanks Tag: How to set the current connectionString user as a defualt value?
  - 15
    - Installing SQL Server 2000 SP3a Sam thank you. I already downloaded the files. Regards Theo Tag: How to set the current connectionString user as a defualt value?
  - 16
    - Bookmark in Code not working. I have a report in reporting services that has a bookmark value asigned to each row. In the following Page_Load event for the page, I'm getting the following error on the ReportViewer1.JumpToBookmark("6") statement: "An exception of type 'System.InvalidOperationException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code Additional information: Some parameters or credentials have not been specified" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Dim strReport1 As String = "/ReportDirectory/CurrentWeekSales" ReportViewer1.ServerReport.ReportServerU rl = New System.Uri(CStr(Session.Item("ReportServ er"))) ReportViewer1.ServerReport.ReportPath = strReport1 ReportViewer1.ServerReport.Timeout = 500000 Do While ReportViewer1.ServerReport.IsDrillthroug hReport ReportViewer1.PerformBack() Loop Dim RptParameters1 As ReportParameter() = New ReportParameter(0) {} RptParameters1(0) = New ReportParameter("EBO_EmpKey", CStr(Session.Item("UserKey"))) ReportViewer1.ServerReport.SetParameters (RptParame ters1) ReportViewer1.ServerReport.Refresh() ReportViewer1.JumpToBookmark("6") End If End Sub What am I missing Thanks Tag: How to set the current connectionString user as a defualt value?

HSBF Lewe

Hi,

I'm using username & password in my connectionString to connect my program (C#.net) with Sql Server 2005..

I put in defualt value in one feild: user_name()

it replace the user: dbo, not the user which I used in my connectionString.

so.. how to get this user

I tried to put: currnet_user

but I get the same result, "dbo" not the user in my connectionString..

Top

Re: How to set the current connectionString user as a defualt value?

HSBF Lewe

I tried SESSION_USER, it gave the same result :(

Top

Re: How to set the current connectionString user as a defualt value?

HSBF Lewe

This is my connectionString:

connectionString="Provider=SQLOLEDB;Data Source=LEWEHSBF\LEWEENG;Persist Security Info=True;Password=HsBfL4w4;User ID=Lewe;Initial Catalog=MyDatabase"

Top

Re: How to set the current connectionString user as a defualt value?

HSBF Lewe

I think the resone is the user I which I used in myConnectionString, is Admin user, I tried with "dataread, datawrite" user and its worked..

Thank you myself

Top