I have a table called 'products'. In each table there is a column named 'description' of type ntext (sql server 2000). The description conains a ton of text and within that text there is an ip address many times. I need to replace every instance of the ip address with the actual domain name, 123.45.678.990 with http://domain.com.
View 5 RepliesI have to Encrypt and Decrypt Back the Password field in sql server i have used the pwdencrypt and pwdCompare() but i dont have to compare but i have to display the password back using the Decrypt technique Is there any algorithm which i can use only for encryption and decryption of password field?
View 4 RepliesI have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesI have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesHow can convert DTS package from SQL Server 2000 to SQL Server 2005
View 2 RepliesDoes anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 RepliesUsing sql server 2000,How to create the dts packages that runs the stored procedure to output the results in excel sheet?
View 3 Replieswt is the difference b/w sql server 2000 sql server 2005
View 4 RepliesSQL query optimation for SQL Server 2000?
[Code]....
What is the best way to move SQL 2000 to 2008 completely? Please let me know if real life problem generally occurs.
View 4 RepliesUnable to read local eventlog (reason: The data area passed to a system call is too small). This error is recorded in the event log every minute in the production server, and because of this the SQL Server 2000 performance is very slow and the box is also working slow. This indirectly affects my application and productivity.
View 2 RepliesI want to synchronise two databases from two different platforms i.e. MS Sql Server 2000 and MySql. I have two applications one is desktop application which uses Mysql and other is Web application which uses MSSql. When any changes made to MySql from Desktop application, then that changes should get reflected to MS Sql database and vice versa. I am novice for this kind of situation.
View 4 RepliesI want to know whether an index is disabled in SQL Server 2000. In SQL Server 2005 we can do this by querying sys.indexes. Is there a way to find disabled indexes in SQL Server 2000?
View 1 RepliesI'm implementing a BLL layer and have a few questions. First, in my DAL, there is a contacts table, the select method is a sql query against a sql server 2000 database. The preview data returns everyting as expected. The query is
[Code]....
The BLL method is built like so
[Code]....
When using the BLL method to a gridview, the results of the subquery are not displayed. There are also other methods, each having a different where clause for ContactRole_ID and each is having the same issue of not displaying the subquery reult in the gridview. No error, but no data is displayed for the subquery either. Here is the templatefield of the gridview
[Code]....
Another item that is causing an error is in trying to update a record. Here is the DAL update method
[Code]....
And the BLL update method
[Code]....
The error says i have extra parameters, but have no clue where the extra parameters are being picked up. The error isObjectDataSource 'odsContacts' could not find a non-generic method 'UpdateContact' that has parameters: _ContactID, _Active, _ContactName, _Office, _VirtualOffice, _Pager, _Fax, _Home, _Cellular, _Email, _ContactRole_ID, Active, ContactRole_ID, ContactName, Office, Email, VirtualOffice, Pager, FAX, Home, Cellular.And the objectdatasource
[Code]....
how to find and replace substring in select query
DATA RELEASE FORM $LSB$DRF$RSB$
I am writing a custom control and implementing ITemplate in it. The code that I am using can be reviewed at the following link: http://msdn.microsoft.com/en-us/library/ms178657.aspx
Under the Template field, I would only like to allow controls of specific type only, say LinkButton and TextBox. If any control(s) present inside Template is anything except LinkButton or TextBox, an error should be thrown. I am wondering how can I check it programmatically inside custom control. The problem is that there is no collection available that lists all the controls that of Template (or may be I am not aware of it.)
how can i select data into temp table from another database in sql server 2000
View 2 RepliesI have come accross a scott's blog today;
http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx
what is exactly Sql server compact edition? it says that I do not need a sql server to store my databases if I use that in my bin folder? so I can use my mdf databases in app_data folder. is that true?
Can VS 2010 connect to a SQL 2000 database?
I get this error while using the Data/Connect and SQL Server 2008 R2 comes up.
"The connection failed because this instance of SQL Server is not supported. The Editor cannot connect to SQL Server 2000 or earlier versions."
Our production server is on SQL 2000
The whole bit about SQL Server is missing in the Add Reference window in :
Microsoft Visual Studio 2010
Version 10.0.30128.1 RC1Rel
Microsoft .NET Framework
Version 4.0.30128 RC1Rel
Installed Version: Ultimate
Microsoft Office Developer Tools 01019-315-4422943-70530
Microsoft Office Developer Tools
Microsoft Visual Basic 2010 01019-315-4422943-70530
Microsoft Visual Basic 2010
Microsoft Visual C# 2010 01019-315-4422943-70530
Microsoft Visual C# 2010
Microsoft Visual C++ 2010 01019-315-4422943-70530
Microsoft Visual C++ 2010
Microsoft Visual F# 2010 01019-315-4422943-70530
Microsoft Visual F# 2010
Microsoft Visual Studio 2010 Architecture and Modeling Tools 01019-315-4422943-70530
Microsoft Visual Studio 2010 Architecture and Modeling Tools
UML® and Unified Modeling Language™ are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.
Microsoft Visual Studio 2010 Team Explorer 01019-315-4422943-70530
Microsoft Visual Studio 2010 Team Explorer
Microsoft Visual Studio Code Analysis Spell Checker 01019-315-4422943-70530
Microsoft Visual Studio Code Analysis Spell Checker
Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.
The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.
Microsoft Visual Web Developer 2010 01019-315-4422943-70530
Microsoft Visual Web Developer 2010
Crystal Reports Templates for Microsoft Visual Studio 2010
Crystal Reports Templates for Microsoft Visual Studio 2010
Microsoft Visual Studio 2010 SharePoint Developer Tools 10.0.30128
Microsoft Visual Studio 2010 SharePoint Developer Tools
Microsoft XNA Game Studio 4.0
Microsoft XNA Game Studio 4.0
Build 4.0.20304.
Where do I find them and how do I bring them into the IDE?
cannot find binn in my sql server express edition..
what might be the problem?
suppose i have few fileds in table and one filed is xml type. how to search this.
the xml which is stored in my xml filed like
<OpenShipments xmlns="x-schema:C:UPSLabelOpenShipments.xdr">
<OpenShipment ShipmentOption="RS" ProcessStatus="">
<ShipTo>
[code]...
we can query sql server data very easily but i dont know how to query the xml data which stored in xml filed.how to query address field in my xml or how to query Options field,how query CompanyOrName.
please help me to construct the sql. guide me in detail with few sample for querying xml datatype.
What is the best way to move my ASPNETDB.MDF from SQLExpress 2000 to SQLExpress 20005 on anothere server
View 2 RepliesWhere can I find the expiration date of SQL Server 2008 Evaluation Edition? It's not in Help >> About and I don't see it in the server properties either.
View 7 RepliesI have a varbinary field in a sql table which is actually a sound file. When I pull that data into a gridivew it is currently showing as byte[]. I would like to make that field a link and when the link is clicked the file will play in the users default media player. I am looking how to pull the varbinary column data and play it for the user.
View 1 Replies