Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 303
Search took 0.03 seconds.
Search: Posts Made By: shahchi1
Forum: SQL Server 2005 September 2nd, 2006, 07:41 AM
Replies: 1
Views: 998
Posted By shahchi1
If you have a table called MyTable with duplicate...

If you have a table called MyTable with duplicate rows

Then

SELECT DISTINCT Col1,Col2.. FROM myTable
INTO NewTable

TRUNCATE MyTable

INSERT INTO MyTable
Forum: SQL Server 2000 September 14th, 2005, 07:47 PM
Replies: 3
Views: 2,890
Posted By shahchi1
You can't do that.. I mean you can't set local...

You can't do that..
I mean you can't set local variable values to text or ntext data type within stored procedure
Forum: SQL Server 2000 September 14th, 2005, 06:50 PM
Replies: 7
Views: 1,672
Posted By shahchi1
are you talking about Log Shipping? ...

are you talking about Log Shipping?

http://www.sql-server-performance.com/sql_server_log_shipping.asp
Forum: SQL Server 2000 August 30th, 2005, 03:04 PM
Replies: 4
Views: 1,393
Posted By shahchi1
I would recommend to create a scheduled job in...

I would recommend to create a scheduled job in SQL Server for truncating your log files.

BACKUP LOG db_name WITH TRUNCATE_ONLY
WAITFOR DELAY '00:00:10'
DBCC SHRINKFILE(dbname_log,targetsize)
Forum: SQL Language August 30th, 2005, 01:32 PM
Replies: 6
Views: 1,054
Posted By shahchi1
and my apology this is a wrox site The...

and my apology this is a wrox site

The Guru's Guide to Transact-SQL - Ken Henderson

Rob Vierra's Professional SQL Server 2000 is a good book for SQL Server 2000
Forum: SQL Server 2000 August 24th, 2005, 10:31 AM
Replies: 3
Views: 3,030
Posted By shahchi1
Are you want to copy table structure and data...

Are you want to copy table structure and data across different databases or SQL Servers? If yes then use DTS,

Right click on your table in the Enterprise Manager-->All Tasks-->
Export Data
...
Forum: SQL Server 2000 August 24th, 2005, 09:47 AM
Replies: 3
Views: 2,025
Posted By shahchi1
Aqua Data Studio is a management tool for the SQL...

Aqua Data Studio is a management tool for the SQL Server relational database w/ administration capabilities and a database query tool

http://www.aquafold.com/
Forum: SQL Server 2000 August 23rd, 2005, 02:52 PM
Replies: 3
Views: 5,067
Posted By shahchi1
How about using INFORMATION_SCHEMA views than to...

How about using INFORMATION_SCHEMA views than to query the system tables directly?

Select COLUMN_NAME = Left(COLUMN_NAME, 20),
DATA_TYPE = Left(DATA_TYPE, 10),
CHARACTER_MAXIMUM_LENGTH as...
Forum: SQL Server 2000 August 23rd, 2005, 12:31 PM
Replies: 3
Views: 1,686
Posted By shahchi1
No it will only truncate the transaction log if...

No it will only truncate the transaction log if you want to backup your transaction log then specify the log backup device using sp_addumpdevice

USE master
EXEC sp_addumpdevice 'disk',...
Forum: SQL Server 2000 August 23rd, 2005, 09:39 AM
Replies: 3
Views: 1,686
Posted By shahchi1
Run this script as a scheduled job in the SQL...

Run this script as a scheduled job in the SQL Server from the Master database


BACKUP LOG database_name WITH TRUNCATE_ONLY
WAITFOR DELAY '00:00:05'
DBCC SHRINKFILE(db_name, 120)


Where...
Forum: SQL Server 2000 July 6th, 2005, 08:24 AM
Replies: 1
Views: 610
Posted By shahchi1
You wanted to give user full access to all DB's...

You wanted to give user full access to all DB's for the SQL server installation
right?

add user to the System Administrator (Sysadmin) fixed server role.

Click on the "Server Roles" tab and...
Forum: SQL Server DTS July 4th, 2005, 12:45 PM
Replies: 1
Views: 677
Posted By shahchi1
http://p2p.wrox.com/topic.asp?TOPIC_ID=32389

http://p2p.wrox.com/topic.asp?TOPIC_ID=32389
Forum: SQL Server ASP July 4th, 2005, 12:43 PM
Replies: 2
Views: 1,107
Posted By shahchi1
text or ntext

text or ntext
Forum: SQL Server 2000 July 4th, 2005, 12:41 PM
Replies: 1
Views: 940
Posted By shahchi1
Cross Post ...

Cross Post

http://p2p.wrox.com/topic.asp?TOPIC_ID=32389
Forum: SQL Server 2000 July 4th, 2005, 12:37 PM
Replies: 3
Views: 13,054
Posted By shahchi1
I am not sure what you have meant by external...

I am not sure what you have meant by external storage on your post, assuming it is a shared network drive

Servername is the machinename you wanted to save your backup files on your windows...
Forum: SQL Server 2000 July 1st, 2005, 09:41 AM
Replies: 3
Views: 13,054
Posted By shahchi1
In the Query Analyzer -- Create a logical...

In the Query Analyzer

-- Create a logical backup device for the full database backup
USE master
EXEC sp_addumpdevice 'disk', 'networkdevice',
'\\servername\sharename\path\filename.ext'

--...
Forum: SQL Server 2000 June 23rd, 2005, 04:40 PM
Replies: 5
Views: 2,443
Posted By shahchi1
Do you mean *masking* user input? Are you...

Do you mean *masking* user input?

Are you referring to it for a web form or for windows application(visual basic application?
Forum: SQL Server 2000 June 23rd, 2005, 01:09 PM
Replies: 9
Views: 7,772
Posted By shahchi1
OR in Query Analyzer right click on the...

OR

in Query Analyzer right click on the results pane, Save As (save as type .csv file)

Then import .csv file into Ms Excel
Forum: SQL Server 2000 June 22nd, 2005, 09:25 AM
Replies: 5
Views: 4,476
Posted By shahchi1
How about below? (cosidering today's date). Also...

How about below? (cosidering today's date). Also , try to post exact error message you were receiving.

SELECT CustName,address, DateEnter
FROM SalesStatusReport_view
WHERE DateEnter >=...
Forum: SQL Server 2000 June 21st, 2005, 01:36 PM
Replies: 1
Views: 619
Posted By shahchi1
Cinderella, Please read this article, it should...

Cinderella, Please read this article, it should help

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
Forum: SQL Server 2000 June 21st, 2005, 01:32 PM
Replies: 1
Views: 1,242
Posted By shahchi1
If it is for MS Access, please post it in the MS...

If it is for MS Access, please post it in the MS Access forum
Forum: SQL Server 2000 June 20th, 2005, 11:35 AM
Replies: 9
Views: 10,865
Posted By shahchi1
Richard, just curious account under which SQL...

Richard, just curious account under which SQL Server is running (not your windows account) have accessed to that shared resource?
Forum: SQL Server 2000 June 20th, 2005, 11:25 AM
Replies: 3
Views: 1,743
Posted By shahchi1
Rand, this is for SQL Server 2005 You might...

Rand, this is for SQL Server 2005

You might want to copy and paste the link in your browser
http://msdn2.microsoft.com/library/7t8a7k10(en-us,vs.80).aspx
Forum: SQL Server 2000 June 17th, 2005, 03:36 PM
Replies: 9
Views: 10,865
Posted By shahchi1
You are right Do not use mapped drives for...

You are right

Do not use mapped drives for SQL Server.
Use a UNC name to reach the backup location:
\\SERVERNAME\SHARENAME

Also

look for sp_addumpdevice topic in SQL Server BOL:
Forum: SQL Server 2000 June 16th, 2005, 09:55 AM
Replies: 9
Views: 10,865
Posted By shahchi1
Please refer to the following artile ...

Please refer to the following artile
http://www.windowsitpro.com/Article/ArticleID/14025/14025.html

The reason is that the MSSQLSERVER service is running under a separate set of NT credentials -...
Showing results 1 to 25 of 303

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.