I think what I am about to ask is impossible, however, figured it was worth a shot here. We have an application that makes use of SQL Servers PWDEncrypt and PWDCompare functions. Part of the system creates duplicates of users (same logon and password). Due to a bug in the system, instead of copying the binary stored PWDEncrypt of a pas...
ALTER PROCEDURE dbo.uspGetOrderTrackingHeaderInfo @ContractID varchar(9) , @SalesRepID int , @StatusID int , @TypeID int , @StartDate datetime , @EndDate datetime , @Identity int = null output AS INSERT INTO [dbo].[tblOrderTracking] ([ContractID] ,[StatusID] ,[TypeID] ,[SalesRepID] ...
Certainly there is some type of context switching, marshaling, serializing, etc that takes place when you choose to write a stored procedure in NET vs T/SQL. Are there any hard facts about this overhead as it relates to making a decision about using .NET vs T/SQL for stored procedures? What factors do you use in order to make the decis...
I have a password protected sql server backup file that I need to restore. In checking all available documentation I believe that the "password protection" doesn't alter the backup file in any way, it's totally readable, it's just there to help ensure that a restore doesn't occur to the wrong database. Is there a way for me to do the r...
Good day, When we add a column to a table, it gets added to the end of the table. However, I really need to add a column to the beginning of the table. The reason is that we have scripts that import data from a flat file source to a table, and that it would be really easier for us to have the columns at the beginning to the table. Tha...
I have a completed web app in PHP 5 + MySQL. I have not yet started its conversion, but it will migrate to ASP.NET MVC + MS SQL 2008. I'm not sure how to progress for the easiest transition: Edit the PHP DAL for SQL Server. Migrate to the new db immediately Leave the live code alone. Create ASP.NET MVC with a MySQL DAL to use for now. ...
Is it a good idea to convert complex views in "db1" into tables in "db2" using SSIS. the purpose of converting views to tables is to make the reports faster. Is there any disadvantages or risks? ...
I have a client database with English and French data in windows-1252 encoding. I need to fetch this data as part of an AJAX call and send it in UTF-8 format. Is there a way I can pass the data through a stored proc to perform this conversion? My web app cannot be altered to perform this conversion itself. ...
We are looking at stress testing a NAS system for a Database, basically was want to see how much abuse it can take and how much it affects the Database performance. here is what we have planed I have a test Tool I'm building that will kickoff a configurable number of threads that run a sql query (also configurable, and thinking abou...
Environment: SQL Server 2005 SP2 (9.0.3077) Transactional Publications (Production and Beta) I have a situation where I have two different Replication Publications setup that use some of the same Articles. Each of these Publications feeds a subscriber on a different machine. One of these shared Articles is a table. At a regular time ...
I have a script task in an SSIS package that is supposed to retrieve a string value from the registry. If the registry value exists and has a value in it it appears to return the value fine. If the registry key does not exist or the value is blank, I can not get it to default a value for some reason. I've tried three different ways of...
I'm trying to build a reliable message service, or at least that's how I would describe it. Here's my problem: I have a table, I insert data into this table, I have at least two applications which select data from this table. However, I need a reliable way for the two different applications to never select the same rows at any given tim...
I have a bunch of utility procedures that just check for some conditions in the database and return a flag result. These procedures are run with READ UNCOMMITTED isolation level, equivalent to WITH NOLOCK. I also have more complex procedures that are run with SERIALIZABLE isolation level. They also happen to have these same kind of chec...
I am building an application which dynamically generates sql to search for rows of a particular Table (this is the main domain class, like an Employee). There are three tables Table1, Table2 and Table1Table2Map. Table1 has a many to many relationship with Table2, and is mapped through Table1Table2Map table. But since Table1 is my main t...
What is the best approach to build a small (but scalable) application that works with Sql Server or Oracle? I'm interested in build apps that supports multiple databases, in the process behind the feature. ...
SQL Server reports can embed vbscript and execute client side, but can the same be done with javascript? I think there would be great utility to be able to execute jQuery and CSS manipulation client side to create a more interactive drill down experience. ...
In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out ASP.Net applications for years. These have usually been based on SQL server and a range of custom tables and views. Just re...
I'm deploying a web site and I need to run large TSQL scripts contained in a single file in a production server where I don't have full access to SQL Server console and I can't connect remotely. The scripts is a mixed of table, stored procedures and views creations. All I can do is to run 1 group of TSQL sentences, like the ones for a st...
I'm making a WinForms app in C#. When I go to create my database object, I'm presented with two options: Local Database Service-based Database All I want is a simple local database to use for my project. However, if I select "Local Database (Compact Edition)" then after I create my tables and drag them over to a LINQ-To-SQL Class...
After some reading and posting, I am fairly sure that I want to use SSDS to analyze some data I have. However, I could use some pointers to help me get going. I have a simple SQL Server table: * PKID (Int) * ApplicationName (VarChar) * MethodName (VarChar) * TimeInMs (Integer) * DateTime (DateTime) This table records the length of t...