Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 303
Search took 0.02 seconds.
Search: Posts Made By: shahchi1
Forum: SQL Server 2005 September 2nd, 2006, 07:41 AM
Replies: 1
Views: 916
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,797
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,596
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,341
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,019
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: 2,934
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: 1,967
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: 4,927
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,627
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,627
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: 561
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: 647
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,053
Posted By shahchi1
text or ntext

text or ntext
Forum: SQL Server 2000 July 4th, 2005, 12:41 PM
Replies: 1
Views: 898
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: 12,955
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: 12,955
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,367
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,656
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,340
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: 581
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,205
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,494
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,656
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,494
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,494
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

 


All times are GMT -4. The time now is 02:03 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.