Viewing 15 posts - 16 through 30 (of 33 total)
The users don't care if we are using SQL2005 they just want the tools they need to do their job.
Hi Judith,
that's really the point that Microsoft will not understand!
January 30, 2008 at 8:15 am
I absolutely agree with you.
Additionaly I think a cycle of 2-3 years is really to short, every 5-6 years for a new SQL-Server version would be good.
For the moment...
January 30, 2008 at 12:29 am
We had the error too. Office 2007 and SQL2K5 Express Edition was installed. After removing the SQL-parts "MS SQL Server Native Client" and "MS SQL Server VSS Client" it worked.
January 28, 2008 at 6:57 am
Gila had the answer.
But, is there no way to refresh in some way the SubSelect while inserting the rows? Some special syntax....?
Tx,
December 12, 2007 at 3:56 am
I think your approaches should work (I didn't test it yet), but nobody answered my question: why does my SubSelect on Table1 not work?
Is the SQL-Engine not so intelligent to...
December 12, 2007 at 3:53 am
Hi Andy,
I have the same problem to find out the user on the client inside a trigger for auditing. Your approach with the context_info seems to be good but what...
August 28, 2006 at 9:00 am
February 10, 2006 at 12:16 am
Hallo Frank,
Here what Scott wrote to me on Otcober 22th:
"kbAlertz is not currently working.
Hopefully I'll get it all fixed this weekend.
Thanks,
Thank you for using kbAlertz.com
--
Scott...
December 23, 2004 at 2:55 am
Try the following:
USE MyDB
DBCC SHRINKDATABASE (MyDB, 10)
BACKUP LOG MyDB WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE (MyDB, 10)
See also MS KB http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
April 15, 2004 at 1:22 am
Take a look a Microsoft KB article:
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
March 23, 2004 at 12:43 am
Danke Frank, it works.
BTW. Am I right, that a single SQL Server data page always contains records from one single table. It can never contain data from two tables?
January 26, 2004 at 2:48 am
Just for information: the forums under http://www.sql-server-performance.com/forum/default.asp have a "Printer friendly" feature.
Patrick SIMONS, MCP
December 22, 2003 at 12:51 am
Thanks Jonathan,
I read the paper (Automating Statistics Management for Query Optimizers ftp://ftp.research.microsoft.com/users/AutoAdmin/stats.pdf). Very **very** complex!
If I understand well, there's no simple rule of thumb. You have to try and to...
December 12, 2003 at 5:20 am
I found the new KB-article 319246. They have a downloadable hotfix now. The problem seems to occur in relation to linked servers.
Patrick SIMONS, MCP
August 20, 2003 at 8:07 am
Viewing 15 posts - 16 through 30 (of 33 total)