Forum Replies Created
Viewing 15 posts - 766 through 780 (of 1,166 total)
-
RE: Need to prevent row-level updates and deletes
I don't think anything other than trigger in scenario...
In your trigger you can check the flag and rollback the transaction if the flag is ON and raise the error to...
-
RE: Installing SQL 2000 and SQL 2005 clients on XP
I did on my laptop, so far no issues...
-
RE: Shrikfile question
When you have multiple log files then you have shrink them individually...and virtual log file is not as large as the original log file size...
SQL Server 2005 Books Online ... -
RE: help with changing a data type
May your coulumn has constraint, so you need to drop the constraint before changing the data type of the coulumn...
create
table tbldetail
-
RE: Configuring SQL to a single cpu
I think You can change in SSMS ...
Processor Licensing Model
http://www.microsoft.com/sql/howtobuy/processor.mspx
-
RE: table from replication??
It is always better to specify complete details when posting so that people can answer better...
-
RE: Anonymous Subscription
Check "anonymous subscriptions" topic in BOL...
http://support.microsoft.com/kb/321822
http://msdn2.microsoft.com/en-us/library/aa237128(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa237125(sql.80).aspx
-
RE: Selecting a dynamic column name
In that case you should use dynamic sql... prepare the statement with and execute it using EXEC () OR SP_EXECUTESQL...
-
RE: Auditing SQL logins
What is the reason you want capture TDS packets?
I don't think there is any way in sql server but you can use NETWORK tools...
-
RE: Memory Usage by SQL Server
Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB). The first counter, SQLServer:Memory Manager: Total Server Memory (KB), tells you how...
-
RE: sqlcmd Utility - Could not open a connection to SQL Server
SQL Server 2005 Connectivity Issue Troubleshooting...
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
-
RE: Tempdb
Begin tran and commit tran will not solve the problem...
You have to figure it out which procedure is causing tempdb to increase...
Run one by one in QA after enabling execution...
-
RE: Installation of SP2 for SQLServer 2005
May be because you are trying to installing on SQL server 2005 CTP not the RTM....Just a gues...
-
RE: Unable to Add New Line Character in SQLServer 2005 Reporting Services
Post this in RS section so that some one can answer from RS team..
-
RE: Is my log corrupted !?
Becareful when you run sp_repldone on production...If you execute sp_repldone manually, you can invalidate the order and consistency of delivered transactions. sp_repldone should only be used for troubleshooting replication as directed...
Viewing 15 posts - 766 through 780 (of 1,166 total)