Is there any free visual query builder that handles the subquery and derived table in an easy way?
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...
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.
it was due the limitation of varchar(Max), I had to cast the concatenated variable to (MAX):
Limitation of varchar(Max)...
it is SQL Server 2005, I found nvarchar(max) also is limited to 8000, what do you suggest?
- I used to use variables in SP as follows:
CREATE PROCEDURE [dbo].[MyProc] (@Crit nvarchar(4000)='')
SET NOCOUNT ON;
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...
- 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:
- 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?
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.
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.