Viewing 15 posts - 391 through 405 (of 447 total)
March 3, 2008 at 2:31 pm
rachel_13 (2/28/2008)
hii have a question . how to find the names of the tables that are being replicated in a database??
select * from distribution..MSArticles
SQL DBA.
February 29, 2008 at 9:11 am
Try this if it helps.
---------------------------------------------------------------------------------------
-- run this from master database only
USE master
GO
IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE name = '##Users' AND type in (N'U'))
...
SQL DBA.
February 29, 2008 at 9:06 am
niranjankumar_k (2/28/2008)
Without droping this table , anyother way just to mention in right order for new column ?
If you don't want to write all script of what John had said....
SQL DBA.
February 28, 2008 at 11:29 am
mark blakey (2/27/2008)
Ok I know I could recode them, but is there way to overide the case sensitivity in insert and update statements so they dont have to be recoded?
Unfortunately...
SQL DBA.
February 27, 2008 at 10:54 am
phani_va (2/26/2008)
Is there any way for me to tell sql server to flush these text col...
SQL DBA.
February 26, 2008 at 1:40 pm
cqldba (2/26/2008)
Also does the DTS packages/settings have connection to...
SQL DBA.
February 26, 2008 at 12:51 pm
You can check by executing dbcc showcontig on the database and then execute dbcc dbreindex command.
Check books online for more details.
SQL DBA.
February 26, 2008 at 12:46 pm
Not possible in SSRS. We had issues displaying report in Arabic language. Developers still in contact with MS and let you know when they get some solution...
SQL DBA.
February 26, 2008 at 11:16 am
This works good both on SQL Server 2000 and also SQL Server 2005.
SELECT object_name(si.[id]) AS [TableName]
, rowcnt AS [Row Count]
, CASE
WHEN si.indid = 0 then 'Heap'
WHEN si.indid = 1 then...
SQL DBA.
February 26, 2008 at 11:11 am
gopal.mailme (1/15/2008)
in few tables whole data is truncated and for few many rows are truncated. few are untouched.. all the affected table are in which bulk upload was done....
kindly help,...
SQL DBA.
February 26, 2008 at 9:43 am
What's the memory size on you server? Let us know your O/S with SQL server version + sp infomation. Also check in server logs if you are having...
SQL DBA.
February 26, 2008 at 9:32 am
wouldn't xp_sendmail work in this scenario?
SQL DBA.
February 22, 2008 at 2:33 pm
Check if this script helps. I found it for long time back on net and was useful to me a lot of time.
---------------------------------------------------------------------------------------------
create table #DBUSERS (DBNAME varchar(50),USERNAME varchar(50), MEMBERNAME...
SQL DBA.
February 22, 2008 at 2:14 pm
$sanjayattray (2/22/2008)
SQL DBA.
February 22, 2008 at 1:57 pm
Viewing 15 posts - 391 through 405 (of 447 total)