Viewing 15 posts - 391 through 405 (of 446 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
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'))
...
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....
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...
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...
February 26, 2008 at 1:40 pm
cqldba (2/26/2008)
Also does the DTS packages/settings have connection to...
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.
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...
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...
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,...
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...
February 26, 2008 at 9:32 am
wouldn't xp_sendmail work in this scenario?
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...
February 22, 2008 at 2:14 pm
$sanjayattray (2/22/2008)
February 22, 2008 at 1:57 pm
Viewing 15 posts - 391 through 405 (of 446 total)