public key in certificate

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Can't connect to server I reinstall sql server develope edition. Then I try to connect the server from another computer, it shows below infomation. But in server property, it allows remote connection. I don't know whether it was caused by reinstall. Before reinstall, I can connect to the server, but it's edtion is group version. And edition for client is also group version. Any one can help me Thank you very much! TITLE: Connect to Server ------------------------------ Cannot connect to *.*.*.*. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Tag: public key in certificate
  - 2
    - UPDATE: Email Report in Outlook 2007 not the same as Outlook 2003 Ditto for me! Tag: public key in certificate
  - 3
    - @@FETCH_STATUS Reset You can use the function to fetch this data.. Sample., Code Snippet Create function dbo . TotalBusinessDays ( @Start datetime , @End Datetime ) returns int as Begin Declare @Result as int ; Set @Result = 0 ; While @Start <= @End Begin Select @Result = @Result + Case When datepart ( weekday , @Start ) in ( 1 , 7 ) Then 0 Else 1 End Set @Start = @Start + 1 End return @Result ; End Go Code Snippet Create Table #events ( [Order] int , [Event1] Varchar ( 100 ) , [Date] datetime ); Insert Into #events Values ( '1' , 'Open' , 'June 1 2007' ); Insert Into #events Values ( '1' , 'Hold' , 'June 10 2007' ); Insert Into #events Values ( '1' , 'Close' , 'June 30 2007' ); Insert Into #events Values ( '2' , 'Open' , 'July 1 2007' ); Insert Into #events Values ( '2' , 'hold' , 'July 10 2007' ); Select [Order] , dbo . TotalBusinessDays ( [Open] , [Hold] ) OpenToHold , dbo . TotalBusinessDays ( [Hold] , [Close] ) HoldToClose From ( Select [Order] , Max ( case when [Event1] = 'Open' Then [Date] end ) as [Open] , Max ( case when [Event1] = 'Hold' Then [Date] end ) as [Hold] , Max ( case when [Event1] = 'Close' Then [Date] end ) as [Close] from #events Group bY [Order] ) as Data Tag: public key in certificate
  - 4
    - Trigger variable to show that zero rows were affected?? Hello, I was setting a @historyActionCode to "I", "U", or "D" as shown below, and then referring to that variable in the trigger code. Code Snippet create trigger [dbo].[tIUD_tablename] on [dbo].[tablename] after update, insert, delete as BEGIN set NOCOUNT on if not exists (select * from INSERTED) select @historyActionCode = 'D' else if not exists (select * from DELETED) select @historyActionCode = 'I' else select @historyActionCode = 'U' But, if a SQL command is issued that affects ZERO rows, like this>>> Update tablename set col1 = 'stuff' where 1=2 Zero rows were actually updated, but the UPDATE trigger will still fire. Since there will be no rows in INSERTED, then the logic will think it's a "D" (delete). Is there a variable I can use right at the top of a trigger to test for ANY rows, and get out if there is nothing to do I was thinking something like this code below.. Code Snippet if not exists (select * from INSERTED) and not exists (select * from DELETED) return Any cleaner/shorter code to do that like, does @@rowcount pass thru to the trigger Thanks, Bruce Tag: public key in certificate
  - 5
    - How to insert multiple values to a column at a time? I would recommend you use Itzik Ben-Gan's Split function: CREATE FUNCTION dbo.fn_SplitTSQL (@arr NVARCHAR(MAX), @separator NVARCHAR(1) = N',') RETURNS TABLE AS RETURN SELECT n - LEN(REPLACE(LEFT(@arr, n), @separator, '')) + 1 AS pos, SUBSTRING(@arr, n, CHARINDEX(@separator, @arr + @separator, n) - n) AS element FROM dbo.Nums WHERE n <= LEN(@arr) AND SUBSTRING(@separator + @arr, n, 1) = @separator; Once you've got this, you could do something like: insert into mytable (col1, col2, col3) select 'Val1', 'Val2', element from dbo.fn_SplitTSQL(N'1,2,3',N',') This should handle it nicely for you. Oh yes, and you'll need a table called Nums with a field called 'n', which you have populated from 1 to some arbitrarily large number. 1000 might be big enough for most of your uses... There's more on this at: http://www.sql.co.il/books/insidetsql2005/source_code/TechEd%202006%20Israel%20-%20Advanced%20T-SQL%20Techniques.txt Rob Tag: public key in certificate
  - 6
    - ExceptionMessageBox What I would like to do is use ExceptionMessageBox to display a message and allow me to customize the buttons, which I believe you cannot do with MsgBox. The example I used is just a simplest case taken from http://msdn2.microsoft.com/en-us/library/ms166340.aspx to test the functionality. I cannot get it to run. All I get is Unable to cast object of type 'ScriptTask_bc7fa8cd8b3c4f4d96407f2b13927e0f.ScriptMain' to type 'System.Windows.Forms.IWin32Window'. Any help would be greatly appreciated, but comments like use something else and SSIS is a batch utility are not helpfull. Tag: public key in certificate
  - 7
    - Reporting Services authenticating with Analysis Services Setup: Reporting Services and Analysis Services are on the same server. Active Directory User. Default configuration of Reporting Services. Problem: Reporting Server does not apply Analysis Services Role after login. Details: I have created a report that retreives data from the Analysis Service. I created a role and added my user company/myUserName to the role. On the Reporting Server I set the data source to : * Credentials supplied by the user running the report and Use as Windows credentials when connecting to the data source Internally when I connect devsql2005/Reports/ReportName I get the user and password fields. When I fill them in I get the report but I can see all the data while my role was restricted to see only few results. Can anyone suggest what may be wrong Any articles or tutorials on how to setup and deploy solutions where Report Server is talking to Analysis Services and NOT Sql Server. Thank You, Pavel Hlobil Tag: public key in certificate
  - 8
    - custom plugin error: how to pass information to Mining Model Viewer? Good morning, Well... As I said in other topics, I'm doing a clustering plugin for text mining. I'm facing many problems and, with your help, solving them one by one. First of all, thanks a lot again. Well... I've made a clustering function that is actually working very well. But I'm exporting its results to a log file I use as an algorithm trace for debugging. My clustering method returns a vector containing information of what cluster each register belongs. For instance: vector[0] = 1 -> The register of index 0 belongs to cluster 1. vector[1] = 9 -> The register of index 1 belongs to cluster 9. vector[2] = 2 -> The register of index 2 belongs to cluster 2. ... And so on. But... I know that none of the Navigation methods receives a structure like this one discribed above. I only use it to log the results to debug the algorithm. But how to pass this information (what register (or test case) belongs to what cluster) to the Navigation Thanks a lot again, and any help will be very appreciated. Tag: public key in certificate
  - 9
    - Documents in VLDB Hi Humberto, The 24 seconds was on subsequent tries. The time varied between 30 and 24 seconds... Here is the code in the vb app... Dim starttime As DateTime Dim interimTime As DateTime Dim endtime As DateTime starttime = Now interimTime = Now endtime = Now Dim msg As String Dim dt As DataTable Dim DBConn As New System.Data.SqlClient.SqlConnection DBConn.ConnectionString = Me .TextBox3.Text DBConn.Open() endtime = Now msg = msg & "Time to open connection: " & ((endtime - interimTime).TotalSeconds).ToString & " seconds" & vbCrLf interimTime = Now Dim cmSql As New SqlClient.SqlCommand cmSql.Connection = DBConn cmSql.CommandType = CommandType.Text cmSql.CommandText = "select doc from tbldocs where docinfoid = " & ID.ToString cmSql.CommandTimeout = 90 Dim ds As New DataSet Dim MyAdapter As New SqlClient.SqlDataAdapter(cmSql) Try MyAdapter.Fill(ds) dt = ds.Tables(0) endtime = Now msg = msg & "Time to load datatable: " & ((endtime - interimTime).TotalSeconds).ToString & " seconds" & vbCrLf interimTime = Now Catch ex As Exception MsgBox(ex.Message) End Try If dt.Rows.Count = 0 Then dt = Nothing 'DAL = Nothing Exit Sub End If Dim ba As Byte () = dt.Rows(0).Item(0) Dim DocName As String = "\doc" & ID & ".pdf" My .Computer.FileSystem.WriteAllBytes( My .Application.Info.DirectoryPath & DocName, ba, False ) endtime = Now msg = msg & "Time to Load Byte Array: " & ((endtime - interimTime).TotalSeconds).ToString & " seconds" & vbCrLf interimTime = Now Diagnostics.Process.Start( My .Application.Info.DirectoryPath & DocName) endtime = Now msg = msg & "Time to open document: " & ((endtime - interimTime).TotalSeconds).ToString & " seconds" & vbCrLf interimTime = Now dt = Nothing 'DAL = Nothing msg = msg & "Total Time: " & ((endtime - starttime).TotalSeconds).ToString & " seconds" & vbCrLf MsgBox(msg) Tag: public key in certificate
  - 10
    - replacing Null values with 0's in Matrix Hi, I am newbie to reporting services and I need some help. Could any one please let me know how to replace Null value with 0 in the data section of the Matrix. I don't want blanks to be displayed on the report, I want those to be replaced with 0's. Thanks for your time. Tag: public key in certificate
  - 11
    - TSQL - Retrieving my Databes index (list) Hi guys, If I have an SQL connection called "SERVER" and into SERVER I have five different Databases like "DB1" "DB2" "DB3" "DB4" "DB5" (each one with it's own Tables / Views / Functions / etc) How can I get the DATABESES LIST Thanks in advance, Aldo. Tag: public key in certificate
  - 12
    - Handling errors returned by SSRS Not sure what you mean by call the event. The event handler will be called for you when the event happens (in this case the report errors out). Tag: public key in certificate
  - 13
    - subcube functions does subcube functions respect the current subcube if I nest them inside a scope Like FREEZE - I guess not LEAVES - I guess yes Is it true if I guess - Scripting Statements - no - Functions - yes HANNES Tag: public key in certificate
  - 14
    - EDI file output any good example of extracting data from sql server 2005 in EDI file format I need to generate EDI files from sql server thanks Tag: public key in certificate
  - 15
    - Client Components Fail to Install - UPDATE Will do. However I'm on the road for another week, and won't be able to do it until I'm back. Thanks again! Niels Tag: public key in certificate
  - 16
    - Help: how to generate sql statements according to parameters in a table-valued function I need to enchance the following function: create function dbo . GetCustomersByRegion ( @PageNo integer , @PageSize integer ) returns table as return ( select * from ( select row_ number () over ( order by customerid ) as row_num , * from customers ) a where row_num >= @PageSize * @PageNo and row_num < @PageSize * ( @PageNo + 1 ) ) How can I replace customers with a select sql statement and customerid with a parameter in the above function They are literals themselves and seem cannot be replaced with parameters. Or I must resort to stored procedure Regards, Ricky Tag: public key in certificate
- Next
  - 1
    - Truncate database tables based on foreign key constraints Guys, I have 600 tables in my database, out of which 40 tables are look up value tables. I want generate truncate scripts which truncates all the tables in order of Parent child relationship excluding lookup tables. Is there any way to do this apart from figuring out Parent Child relationship and then writing the truncate statements for each of the table. For example EmployeeDetail table references Employee table DepartmentDetail table references Department table Department table references Employee table My truncate script should be TRUNCATE TABLE DEPARTMENTDETAIL TRUNCATE TABLE EMPLOYEEDETAIL TRUNCATE TABLE DEPARTMENT TRUNCATE TABLE EMPLOYEE Is there any automated way to figure out parent and child tables and generate truncate script for the same. Thanks Tag: public key in certificate
  - 2
    - Problem with Lesson 3 in the Analysis Services Tutorial I am at the step of "Adding an Attribute and Defining Display Folders" where I am experiencing problems. The steps are: 2. In the Attributes pane, select the following attributes by holding down the CTRL key to select multiple attributes, and then in the Properties window, set the AttributeHierarchyDisplayFolder property for the selected attributes to "Location": ? City ? Country-Region ? Postal Code ? State-Province 3. In the Hierarchies and Levels pane, click Customer Geography, and then select "Location" as the value of the DisplayFolder property in the Properties window. The problem is that there are no choices in the DisplayFolder property of the Customer Geography hierarchy. I do not know how to force "Location" into the property drop down list. The rest of the tutorial has been fine up to this point. What am I missing Tag: public key in certificate
  - 3
    - Connector between executables dissapears Dear Forum Members. I am currently using Visual Studio 2005: Business Intelligence Development Studio to create an Integration Services Package. The package contains several containers, within each container there is a ��foreach loop container�� and within the ��foreach loop container�� there is a script component, execute component and another script component. Each of the three components is connected together by single connectors. My issue arises when I disable a container and then enable the container; the connectors between the components disappear (e.g. are not visible) but do exist as I can not create another connector between the components. When I attempt to create the connector again between the components I receive the error message. This tells me the connectors are present but not visible. TITLE: Microsoft Visual Studio ------------------------------ Cannot create connector. Only one workflow can exist between the same two executables. ------------------------------ BUTTONS: OK ------------------------------ Can someone kindly explain why this is happening and how to resolve this issue I can not change the connector types from success to completion or vice versa because the connectors are not visible for me to select them. Many Thanks Tag: public key in certificate
  - 4
    - Need to Subtract the result of two stored procedures Thanks I will give it a try and keep you posted. Tag: public key in certificate
  - 5
    - SSIS Logs Vs Custom Logs components Hi, In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error. Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though. Now what will a custom log provider help me to do in this case. Also can I somehow configure my package to call the send mail task everytime an error is raised. Also, one more option can be developing a package that only does the error handling. It will take in the paramters or the error codes and descriptions, the destination to write to and a flag to send mail or not for that particular type of error. What do you think Kindly advise. Thanks in advance for your help and time. Regards, $wapnil Tag: public key in certificate
  - 6
    - Parse text file (csv, fix width), Perl or something newer? The files are downloaded from the web so I cannot control the format. The format is consistent for each individual file. It still has some rules even for different files, for example, one file may have columns: CustomerNo, Amount, OrderID, ..... while another file has OrderNo..(some extra columns)., AMT, ...(some extra columns).., CustID,... Amnt, ....., CID, OrderNumber,... We used to write a Perl script to parse the files and generate a set of CSV files with constant column names. The Perl script keep all the alias of columns names so CustomerNo will be matched to CustID and CID, etc.... Any way to handle it in SSIS Tag: public key in certificate
  - 7
    - protected sql database file Hi..... Thanks for your solution, there is a quetion plz. Can I Change the owner of the database I mean I will create the database by sa user, and I will add new user, can I make him the owner Tag: public key in certificate
  - 8
    - Old Excel files after SQL2000 > SQL2005 migration I suspect the problem is how the old datasource stored off the application name in it's internal connection string. If the string contains the words "Microsoft Query" then our driver will send this dbcc traceon statement. So new queries must not be adding this to the connection string. Unfortunately I don't see a way to modify the connection string that Excel is using it appears to be embedded in the spreadsheet somewhere. Tag: public key in certificate
  - 9
    - Dynamic SQL Cells How can I make the values for certain cells in a table in a database show the day a folder was created On the same note, How can I make other values in other cells change (say the values 101 through 200 had to change to 1-100) Tag: public key in certificate
  - 10
    - Database mirror certificate expired Hi Remus I also have a question. When initially creating the certificates is there a way to specify the validity By default I saw it is 1 year. Maybe put 5 years right from the beginning... salut Tag: public key in certificate
  - 11
    - create local cube issue Could you make sure that cube file is not opened from any other application and that it's not write protected or something like this May be just delete this file and try to create it again. The other thing that comes to mind are permissions for directory, but you are obviosly an administrator on your machine and should have permissions to your own c:\ drive. Is it Vista by any chance Tag: public key in certificate
  - 12
    - Seek in a SQL table from Access I have an MS Access 2003 database from which I want to seek a specific record in a SQL Server Express 2005 database. I can connect to the table and get a recordcount but the recordset.supports (adseek) and recordset.Supports(adIndex) both return false. Any suggestions Specific code I'm using is as follows: Dim cnxn As ADODB.Connection Dim strCnxn As String Set cnxn = New ADODB.Connection cnxn.Provider = "sqloledb" strCnxn = "Data Source=SERVER\SQLEXPRESS2005;Initial Catalog=RAMPSQL;Integrated Security='SSPI';" cnxn.Open strCnxn Set rsWSC = New ADODB.Recordset rsWSC.CursorLocation = adUseServer strSQL = "DailyData" rsWSC.Open strSQL, cnxn, adOpenKeyset, adLockReadOnly, adCmdTableDirect Thank you! Tag: public key in certificate
  - 13
    - SQL2005 64bit, snapshot creation error I'm running SQL Server 2005 SP2 64bit under Windows Server 2003 64 bit The system is the replication distributor as well. Transactional replication. But I can't create the snapshot! I have run snapshot.exe repeteadly with all parameters in a command prompt and it crashes at various BCP percentages. The error is like this: 2007-10-16 00:38:56.32 [10%] Bulk copied snapshot data for article 'Dictionary (part 14 of 20)' (1656 rows). 2007-10-16 00:38:56.32 [10%] The replication agent had encountered an exception. 2007-10-16 00:38:56.32 Source: Replication 2007-10-16 00:38:56.32 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException 2007-10-16 00:38:56.32 Exception Message: Data conversion failed 2007-10-16 00:38:56.32 Message Code: 02007-10-16 00:38:56.32 2007-10-16 00:38:56.32 Call Stack: 2007-10-16 00:38:56.32 Microsoft.SqlServer.Replication.NativeSqlConnectionException: Data conversion failed 2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper) 2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause) 2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem) 2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc() 2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.MainWorkerThread.AgentThreadProc() 2007-10-16 00:38:56.32 at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() 2007-10-16 00:38:56.33 [10%] Bulk copied snapshot data for article 'Dictionary (part 15 of 20)' (1487 rows). 2007-10-16 00:38:56.33 [10%] Bulk copying snapshot data for article 'Dictionary (part 20 of 20)' the fact that BCP continues to copy data after the error makes me believe the crash occurs somewhere else. How can I isolate the offending table Can I capture the BCP commands issued Any insight will be appreciated. Tag: public key in certificate
  - 14
    - SQL 2000 Maintenance Plan failure I am noticing the delete step randomly skipping backups older then the maintenance setting. These backups were named by the maint plan and were not changed. For example, of the 5 databases that I created a full backup for, 1 failed. The maint plan log stated that there 0 files to delete even though there was definitely one to delete. Space was not an issue. The db backup that was skipped is 1.5mb and I have over 40 GB free on the drive. Any suggestions Thanks Tag: public key in certificate
  - 15
    - Morning checks for DBA's Hello I was wondering what the first tasks and checks are you do when you come in the office in the morning Example: check jobs check blocked processes check replication ... Worf Tag: public key in certificate
  - 16
    - SSIS Import of CSV don't recognize NULL values for VARCHAR fields Hi, i'm new to SSIS and trying to import some csv files (comma delimited) into SQL Server. A NULL value for a CHAR column is correctly regonized as NULl in SQL Server, but a NULL value for of a mapping to a VARCHAR column in SQL Server is not recognized correctly and i get the value "'NULL'" in SQL Server (including the single comma. Sample: CSV file contains columns A and B. A and B contains the Text NULL. Column A is mapped to a CHAR field, and column B is mapped to a VARCHAR field in SQL Server. After the import, SQL has the following value: A = NULL as NULL, B 'NULL' as text. did anyone else had this problem thanks so much for any help. Tag: public key in certificate

purusingh

<code>

CREATE CERTIFICATE SalesCert

encryption by password = 'blabla'
WITH SUBJECT = 'Sales cert',
EXPIRY_DATE = '10/31/2009'
GO

</code>

When I create certificate using such tsql where is the public key.

Top