Programming SQL
in [Microsoft SQL Server]
|
DBCC Memorystatus Results across a linked server declare @lnvc_SQL nvarchar(4000) select @lnvc_SQL = N'select * from openquery([HQAPPSQL04], ''set fmtonly off; ' + ' exec (''''dbcc memorystatus'''')'')' exec sp_executeSQL @lnvc_SQL Does anyo... 22 Apr 2010 09:18
Tracking results of changes to database Is there a good tool for testing results of changes to stored procedure, functions, views etc? Some way to compare results of activity to the results of the same activity after changes are made. Not just for a particular procedure but after you have made changes to multiple procedures that may be used by ot... 20 Apr 2010 18:34
sqlcrl exception >> attn Charles Wang << Hello Charles , I just saw your response on microsoft.com/communities - I found it via google as it never showed up on the newsgroup ?!? The problem isn't the that the exception is thrown ( in fact I want the user to see them ) , the problem is that once an exception is thrown the web service call will fail... 22 Apr 2010 06:11
SQL Server 2000, Non-Clustered Index Creation and Blocking I have tried to test this, but even with 30 million records int he table the index is created so fast that executing the query and hitting an sp_who2 isn't either showing a block, or there isn't one at all. Does anyone know if creating a non-clustered index is a blocking operation? I was thinking it might be if... 19 Apr 2010 12:37
SQL Server 2000, Non-Clustered Index Creation and Blocking I have tried to test this, but even with 30 million records int he table the index is created so fast that executing the query and hitting an sp_who2 isn't either showing a block, or there isn't one at all. Does anyone know if creating a non-clustered index is a blocking operation? I was thinking it might be if... 20 Apr 2010 09:18
Migrating from MsAccess to MS SQL Hi all We have some intranet thing, which needs to be transferred from MS Access to SQL server. I have serious problems with fieldnames and tablenames with spaces, and using SQL Explorer is even hard. MS SQL Server can import from MS Access, but I cannot see into certain tables without SQL Explorer simply c... 20 Apr 2010 08:17
alternative of xp_smtp_sendmail in sql server 2008 Hi, I have moved my database sql server 2000 to sql server 2008 and on 64 bit. For mail I used xp_smtp_sendmail but this is not working in sql server 2008 .. Please suggest me alternative for this Thanks, Hemant ... 22 Apr 2010 03:05
Arithabort Can AnyOne Tell me About Arithabort Option in Sql server.What Are its utilities.and I Also Some Issues While Searching About Arithabort that it affects Query Execution Timimgs Also.Please Explain ... 19 Apr 2010 05:21
Conversion failed when converting datetime from character string Hello: I get the following error message in SQL 2005 Management Studio: Conversion failed when converting datetime from character string. I get this when I run a "select * from" query against a view called "DEBITMEMOGLFISCALYEARS". Here is the programming of this view: ALTER VIEW [dbo].[DEBITMEMOGLFISCALYE... 18 Apr 2010 23:03
set ARITHABORT on I have a SQL 2000 database that I just reindex a table. After I do that, in my program before I can delete/insert I need to "set ARITHABORT on", otherwise I get an error. Also, a select statement without it runs very slow. Why after I re-index a table I need to "set ARITHABORT on" in my program ? How can I set it... 21 Apr 2010 03:16 |