Viewing 15 posts - 151 through 165 (of 194 total)
I'm not sure whether this will help you or not. But still I'just came across the following and thought of distributing to you.
Examples
This example returns the book with the highest...
October 23, 2007 at 7:55 am
create a trigger which is considered to be the primary source for pulling the data to your report. This should be identical.
check for the examples of creating trigger to the...
October 23, 2007 at 6:21 am
kindly spilt your view / query & point the area where u need the answer
October 23, 2007 at 6:11 am
in sql 2000 --> go to entprise mgr --> select your server/database -->data transformation services -->local packages.
There u can find all of your dts then right click any of the...
October 23, 2007 at 6:03 am
this can happen due to some users try to hit the server / database for reteriving the information. So, at this point the chances for DTS might be slow.
Else, the...
October 23, 2007 at 5:59 am
example
_______
ip address :- 165.30.130.88
user-id :- worlduser
password :- worlduser
____________________________________________________
this will work in both enterprise mgr & qry analyser.
October 23, 2007 at 5:56 am
My way of creating back-up is to run through the script file by mean of Data publishing wizard. That has the advantage of having both data & schema.
This will be...
October 23, 2007 at 5:51 am
before running the SP/QRY try to figure out the local datetime setting of your server. And then use the following query ;_
1) SET DATEFORMAT mdy or
2) SET DATEFORMAT ydm or
3)...
October 23, 2007 at 5:47 am
even i'm not sure whether this work. Just by dropping & attaching the respective objects into the server might tamper the operational behaviour too.. Better try the same in a...
October 23, 2007 at 5:42 am
this might be due to bad configuration of your sql too.. better copy the error message from event log & send it across...
October 23, 2007 at 5:19 am
try this SP and implement accordingly....
http://www.codeproject.com/cs/library/datetimelib.asp?print=true
October 23, 2007 at 5:16 am
check this site....
http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes
October 23, 2007 at 5:09 am
Allow the users to connect to the databases through Windows Authentication as this will work for them to browse through the entire databases. If you are specific about SQL authentication,...
October 23, 2007 at 5:00 am
I think its done by means of algorithim which is seeking a unique word of the topic that is being published as a news over the news. Hence, each and...
October 23, 2007 at 4:39 am
Viewing 15 posts - 151 through 165 (of 194 total)