Viewing 15 posts - 661 through 675 (of 1,884 total)
Profiler is the quick answer.
Did you mean server side traces?
July 17, 2006 at 3:10 pm
Hi,
did it create installation file with your selected options %windir%\Unattended .ISS ? The actual install should not take place, just the file has to be created.
July 17, 2006 at 3:02 pm
I think it is similar. You may also try this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
July 17, 2006 at 2:55 pm
Mark,
Could you post a reference or instructions on how to setup SQL Mail with Notes client?
July 17, 2006 at 11:05 am
Read:
http://msdn2.microsoft.com/en-us/library/ms345408.aspx
Moving System Databases
The first query in this article applies to all system databases except for Master and Resource, follow the instructions in the article.
If it does not help...
July 17, 2006 at 11:01 am
Hi,
Classic ORM is Object Role Modelling, not Object Relational Mapping.
Everything else in this article about SARG is brilliant.
Here are the references to the source on ORM:
http://www.orm.net/pdf/springer.pdf#search='terry%20halpin%20object%20role%20modeling'
July 17, 2006 at 10:49 am
Hi,
I had a similar case some time ago:
- Restarted SQL Server, but not the Windows Server.
-Some clients could connect and some could not
-Rebooted Windows Server, everyone is happy.
This is...
July 14, 2006 at 3:06 pm
Did you try OPENROWSET?
Also, going back to the original problem, I had problems with Distributed Transaction Coordinator message "Unable to participate in Distributed Transaction" when going towards some servers with...
July 14, 2006 at 2:00 pm
Did you try to:
Insert dbo.track_case_action...
Select * from Deleted
Like:
INSERT INTO MyTable (PriKey, Description) SELECT ForeignKey, Description FROM SomeView
See...
July 14, 2006 at 1:47 pm
Depends who is asking...
Use today's Question of the Day:
Select @@Options
to return a bit mask for user options. See "User Options Option" article in BOL for the number for each option....
July 14, 2006 at 10:07 am
I saw these cases when the default protocol for the client on one server is TCP/IP and on another server is Named pipes. Port 1433 (or whatever you are using) may...
July 14, 2006 at 9:53 am
You really have to consult with your application vendor. It looks like the task of creating or upgrading a database fails because of the syntax. Some syntax was obsolete from...
July 14, 2006 at 9:47 am
ALTER SCHEMA schema_name TRANSFER object_name
see Alter Schema topic in BOL
July 12, 2006 at 11:51 am
Viewing 15 posts - 661 through 675 (of 1,884 total)