Is there any free visual query builder that handles the subquery and derived table in an easy way?
Hi Luis, I don't like to duplicate posts, but after I post it I saw the words [Forum Closed] so I thought I had to post it in different forum.
I want to make the mirroring for one of the replicated servers not making replication to a mirrored server. I have SERVER1 which is publisher to...
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...
FOUND IT... it was due the limitation of varchar(Max), I had to cast the concatenated variable to (MAX): Limitation of varchar(Max)...
Hi Jon, it is SQL Server 2005, I found nvarchar(max) also is limited to 8000, what do you suggest?
hi - I used to use variables in SP as follows: CREATE PROCEDURE [dbo].[MyProc] (@Crit nvarchar(4000)='') AS Begin SET NOCOUNT ON; declare @SQL...
Yes, 1- I do the replication to times, one time for Head Office to branch and second time from branch to Head Office and I do some updates in...
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...
1- By using CDC, I will be able to know exactly who made changes ? 2- Am I able to change the cleanup schedule?.
1- does CDC expand the log file? 2- can I truncate the CDC table any time?
the purpose of view the transaction log file for a database to me is to see what actually happened in the right sequence, for example: update sales...
- 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...
Sorry, I know I am in the wrong forum, am using Sql server 2005, so what is the best option for me?.
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 using unicode date types (nvarchar), but the collation of the column is <database default> which is Latin, but I do not want to change it.
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,...
Separate names with a comma.
