Is there any free visual query builder that handles the subquery and derived table in an easy way?
hi, I'm planning to make mirroring to my SQL Server, but I have two questions: 1- My DB is involved in replication, so my question is the mirrored...
Hi, I want to upgrade the installed SQL Server 2005 license from developer edition to EE, but I do not want to uninstall and install the EE. is...
hi - I used to use variables in SP as follows: CREATE PROCEDURE [dbo].[MyProc] (@Crit nvarchar(4000)='') AS Begin SET NOCOUNT ON; declare @SQL...
Hi, - I am using a vb6.0 application based on the ReplSamp using sqldistx.dll (Microsoft SQL Distribution Control 9.0) to send the data in the...
- is there a way to browse and/or recover the database log file? nothing new in SQL server 2008? - if I should use 3rd party, what is the best advice?
What is the best reporting technique should I use with crystal reports and SQL server to get the best reporting performance? - use SPs? - summary...
Hi,I'm Using:SELECT * FROM OPENROWSET(BULK 'G:1.jpg', SINGLE_BLOB)to save binary files from hard disk to sql server databaseNow I need an SQL code to...
Dear Sirs, I am writing a device application that connects to SQL 2005 srever (collation is Arabic_CI_AS on the server), it is working just fine,...
Hi, How can I change field size for replicated database?, when I try to do so I get the message" - Unable to modify table. Cannot drop the table...
Dear All, below is an SP running well, but it gives a strange behavior with the bcp utility The SP: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO...
Dear All, I want to know how to make an SQL Server stored procedure that runs every Thursday for a given parameter period and exports the result in...
HI All, I want to write a SQL statement with max() funcion but with multiple fields outputs, here is the case: The Data: Student...
Hi, When I try to delete some records from the primary table it says that it has related records in other tables, my questin is : - Is there a way to...
Hi, I am making an application uses SQL Express, I wonder if I can secure the mdf, so that non-autorized people can open it. is it possible? Thanks
Hi All, My Database was corrupted this morning, it uses a transactional replication, it was in suspect state, I could not recover, I got the last...
Hi All, I want to be able to read file name or directory structure located in Sql Server local disk through Visual basic, this is helpfull for me...
Hello all, I am making transactional replication between 2 servers through IP VPN (Server A and Server B), one of them is publisher and the other...
Separate names with a comma.
