Is there any free visual query builder that handles the subquery and derived table in an easy way?
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...
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.
- I used to use variables in SP as follows:
CREATE PROCEDURE [dbo].[MyProc] (@Crit nvarchar(4000)='')
SET NOCOUNT ON;
- 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?
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...
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,...
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...
below is an SP running well, but it gives a strange behavior with the bcp utility
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
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...
I want to write a SQL statement with max() funcion but with multiple fields outputs, here is the case:
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...
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?
My Database was corrupted this morning, it uses a transactional replication, it was in suspect state, I could not recover, I got the last...
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...
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.