Hi,
I had posted this yesterday, but since I didnt get any response Iam posting it again.
Iam having a SQL database replicated to a webserver.It is using snap shot repl and the prob now is that as the
data grows it takes time when the snapshot is applied, so the webcontent goes blank for abt...
Hi,
Iam having a SQL database replicated to a webserver.It is using snap shot repl and the prob now is that as the
data grows it takes time when the snapshot is applied, so the webcontents goes blank for abt 2-3 mins.I had first tried
transactional , but as the keys(PK) were not getting...
I need to write a procedure for :
I have a table- tab1 which has cols- ikey,status and place.
I have another table tab2 which is to be updated/inserted which also has the same cols and more
A row present in tabl1 where the ikey is same as that in tab2 and has tab1.status = a and tab1.place =...
Hi,
Iam replicationg db7 database in one server to db6 in another server.
In db6 when I select the rows from a table in using EM ,it gives
" [Microsoft] [ODBC SQL Server Driver]Timeout expired" error.What could be the cause
of this error and how can I overcome it ?
Thanks
Rick
Hi,
I have a table T1 which contains style(PK) and Product and another table T2
which contains style (PK) and some other cols.I want the result as 1 if all the styles of a product in T1 exists in t2
otherwise 0.How Can I write a query ,can somebody help.
Rick
Hi,
Iam trying to bring data from a text file to sql server table using DTS.
The last 4 characters of the last field are getting truncated after dts is executed
.I cannot extend the column
break for the last field (Beyond the red line)in dts for the text file.Is there a limitation for the...
Hi,
Is there any method to achieve DISTINCT with text datatype columns.
Sql doesnt allow DISTINCT with text columns.Even though I dont
need to use distinct directly to a TEXT column, text columns which is
part of a join is creating problems
Thanks
Rick
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.