|
|
|
November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Need help to setup profiler at server side Posted by Sunny at 12/28/2004 3:54:24 PM I have created one trace with Security Audits event only and about 10 data
columns and no filter. Which runs fine SQL profiler. I just want to trace
users activity on server. But I want to keep this trace running on the
server. How can I setup to run trace on server from client. I have admin
rig...more >>
Make a test copy of a live database Posted by jerryk at 12/28/2004 9:24:15 AM Hi,
I need to make a copy for testing purposes of the a live database. I am not
concerned that my data is completely accurate, ie. can handle seeing a
transaction in action. The one thing I cannot do is detach the database,
since the database is operational 7 X 24. Any thoughts on the best ...more >>
Configuring BizTalk Server 2004!! Posted by Shyam at 12/27/2004 8:43:01 PM Hello,
I've installed BizTalk Server 2004, but was not able to configure it.
I tried few possibilities and was not successful. As i'm new to BizTalk
Server, can some one help in configuring it. Please provide me with steps to
follow or any website where a detailed description is given.
Kind...more >>
DTS Scenario Problem...a bug found!!! Posted by Shyam at 12/27/2004 8:15:01 PM Hello,
I've a problem in DTS.The following is the scenario:
The DTS which i developed is scheduled to run every day thru JOBS.
The DTS has to check for the new data which has come in the past 24hrs and
it connects between Oracle and SQL Server.
So,when ever the new data comes fromOracle to SQL...more >>
Single Trigger to Multiple Tables Posted by Saradhi at 12/24/2004 6:48:09 PM Can I assign a single Trigger to multiple tables?...more >>
UniqueIdentifier Data Type Posted by Jeff Cobelli at 12/24/2004 1:28:38 AM I am trying to pass a UniqueIdentifier as a parameter to a SQL Server stored
procedure from a .asmx webservice. Whenever I try to run it, I get the
following error: "Invalid cast from System.String to System.Guid." I have
tried changing the datatype of the parameter in the WebMethod but noth...more >>
Definitive Book for SQL Server 2000? Posted by Bill M. at 12/23/2004 11:39:39 PM I am trying to learn more about SQL Server 2000 and wonder if anyone can
recommend a book to help? Thank you.
...more >>
What is wrong with this query? Posted by Monty at 12/23/2004 8:49:33 PM I am tired and it looks correct but I get a syntax error near MOVE
use master
go
restore database MMS_CSS_DATA
from disk = 'C:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\MMS_CSS_DATA\MMS_CSS_DATA_db_200412211730.BAK'
with norecovery
MOVE 'InventorySQL_dat' to 'C:\Program Fil...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Exporting MS SQL Posted by Zagor at 12/23/2004 1:01:39 PM Hi All,
thank you for you time in advance.
I am new to MSSQL, and I managed to create a sample database in my local
machine, query the database etc.(using ASP.NET and C#)
My next step is to "upload" the database to the Hosting service which
support MSSQL. There is alot information on the net,...more >>
Triggers and Stored procedures Posted by ªL©ú©v at 12/23/2004 11:37:26 AM Dear all:
I have three table named A, B and C. If any data inserted into or
updated to table A, a trigger of A will deal with data extraction and write
extracted data to B and C.
And, B has a trigger to deal with other data consistency job, a stored
procedure named sp_D. This stored pro...more >>
Database hits Posted by foobar at 12/22/2004 12:54:38 PM I have an asp.net page that is querying an SqlServer Db for various data to
be displayed. Is it better to hit the database several times to pull this
data over to the page or, should my stored procedure contain several select
statements thereby only connecting to the database once?
...more >>
Sending automatic mails daily by executing stored procedure Posted by Sai Ashok at 12/22/2004 2:39:09 AM hi all,
I want to send email daily by executing a stored procedure. This stored
procedure should be automatically executed daily. I want to use my existing
official company mail id for sending emails ( i cant create separate mail id
for that).
Kindly reply .
--
Regards
Ashok s p
Lov...more >>
DTS batch and PLAN Posted by Andriolli Arrigo - Italy at 12/22/2004 1:29:02 AM We have a DTS SqlServer that run every nigth at 4.00 am. To accelerate this
execution i would like to re-utilezed the access plan created the previous
night, but every night the DTS recreated the access-plan because the work
during the day clean and write the memory.
As can I resolve this pr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |