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 500
Search took 0.13 seconds.
Search: Posts Made By: happygv
Forum: Book: Professional Microsoft SQL Server 2008 Administration ISBN: 978-0-470-24796-9 March 28th, 2011, 05:13 AM
Replies: 0
Views: 4,820
Posted By happygv
Table of contents - reference to 2005?

Hi,

Why do TOC contain reference to SQL 2005 for a few topics? I guess it is a typo, it should have been 2008 instead of 2005.

Refer this link -...
Forum: SQL Server 2008 March 28th, 2011, 04:46 AM
Replies: 0
Views: 2,332
Posted By happygv
Merge Replication Failure since Upgrade of SP2

Hi,

Here is the scenario.

Publisher is on SQL 2008 with SP1
Subcribers are on MSDE 2000 with SP4 (2 subscribers)

Recently the Publisher machine was upgraded to SQL 2008 SP2, and right after the...
Forum: SQL Server 2008 January 16th, 2010, 04:07 AM
Replies: 0
Views: 839
Posted By happygv
Reporting services Authentication config

Hi,

I have setup the reporting services and deployed some reports. We view the reports through a web application. But while clicking on the link to the report from web application, it always asks...
Forum: SQL Server 2000 July 31st, 2009, 02:53 PM
Replies: 11
Views: 25,617
Posted By happygv
Good one. I was looking for something like this...

Good one. I was looking for something like this to compare two datetime values and return the delay in the format HH:MM:SS. This one really helped.

Thanks
Forum: SQL Language May 21st, 2009, 11:34 AM
Replies: 7
Views: 1,172
Posted By happygv
Do you have the User's selection, saved in the DB...

Do you have the User's selection, saved in the DB somewhere?
Forum: SQL Server 2005 May 20th, 2009, 01:51 PM
Replies: 4
Views: 1,103
Posted By happygv
DISTINCT results in unique rows, so the SELECT...

DISTINCT results in unique rows, so the SELECT list should be taken care accordingly.
Forum: SQL Language May 20th, 2009, 01:40 PM
Replies: 1
Views: 1,000
Posted By happygv
I don't think I understood that. Looking at the...

I don't think I understood that. Looking at the SQL code, I wonder what does FIELD count mean there?


You should be looking at indentation (tabbing the lines accordingly) of code to avoid counting...
Forum: SQL Server 2000 May 20th, 2009, 01:32 PM
Replies: 3
Views: 1,085
Posted By happygv
You may need to look at those scripts and change...

You may need to look at those scripts and change it a bit in terms of syntax. and some of the statements that are different between MYSQL and MSSQL atleast to start with the CREATE DATABASE...
Forum: SQL Language May 18th, 2009, 09:41 AM
Replies: 2
Views: 1,002
Posted By happygv
Hi rajesh_css, I am not sure which DBMS you...

Hi rajesh_css,

I am not sure which DBMS you use, and what you actually wanted in this case. Just giving a try to see if this helps.
select Name,
SUM( (SELECT count(total) from X T1 where...
Forum: SQL Server 2000 May 18th, 2009, 09:25 AM
Replies: 1
Views: 775
Posted By happygv
I don't think you could. AFAIK, you can only set...

I don't think you could. AFAIK, you can only set password for users/logins within the database for their access, not while attaching/detaching.
Forum: SQL Server 2000 May 18th, 2009, 08:39 AM
Replies: 1
Views: 767
Posted By happygv
How do I encypt the Code

Hi,

I was thinking a lot on (may be call it "ENCRYPT") having the SQL code in Procedures/Triggers/Views not readable to "others". May be I dont get the right term other than encrypt while composing...
Forum: SQL Server 2005 January 8th, 2009, 03:10 AM
Replies: 3
Views: 869
Posted By happygv
Does the system time on both the publisher and...

Does the system time on both the publisher and subscriber look same or different?
Forum: MySQL January 8th, 2009, 02:49 AM
Replies: 8
Views: 2,042
Posted By happygv
Another way to do that is wrap the text in DOUBLE...

Another way to do that is wrap the text in DOUBLE QUOTEs.

"I'm"

Hope that helps.
Forum: MySQL January 6th, 2009, 08:16 AM
Replies: 3
Views: 780
Posted By happygv
Hi, You may need to use the ID field as a...

Hi,

You may need to use the ID field as a reference in that.

1 John
2 Peter
3 Sam

You need to have your View links to have hyperlink with a querystring carrying 1 for John, 2 for Peter,...
Forum: MySQL January 5th, 2009, 03:59 AM
Replies: 2
Views: 1,214
Posted By happygv
my.ini won't be found under C:\Windows It...

my.ini won't be found under C:\Windows

It should be on MYSQL's folder under Program Files something like...
C:\Program Files\MySQL\MySQL Server 5.0
Forum: SQL Language December 26th, 2008, 08:35 AM
Replies: 15
Views: 2,005
Posted By happygv
In addition to Imar's suggestions, I think the...

In addition to Imar's suggestions, I think the statement is syntactically wrong.

In your case SELECT... FROM... GROUP BY... ORDER BY is the sequence.
Forum: SQL Server 2000 October 24th, 2008, 02:13 PM
Replies: 0
Views: 716
Posted By happygv
Database connnection fails often

Hi,

The application that is developed using VB, seems to report disconnection to database (sql server 2000) very often. It is supposed to retry and the same is connected during retries. I dont...
Forum: SQL Server 2000 October 24th, 2008, 02:03 PM
Replies: 1
Views: 1,862
Posted By happygv
Hi, Are you sure you have tables and procedures...

Hi,

Are you sure you have tables and procedures created in it?

when you say "Can't see table/sps", how are you trying to view those objects?

Thanks

_________________________
- Vijay G
Forum: SQL Server 2000 April 9th, 2008, 03:27 AM
Replies: 0
Views: 4,633
Posted By happygv
SQL Server does not exist or access denied

Hi,

I recently see this error occur often at different times on SQL server Agent Log. Please see the log extract as given below.

1) there is no sign of the SQL server shutting down ( SQL server...
Forum: SQL Server 2000 September 10th, 2007, 08:38 AM
Replies: 17
Views: 4,623
Posted By happygv
Jeff, Thanks for pointing it out, It was my bad,...

Jeff,

Thanks for pointing it out, It was my bad, I somehow thought that we are dropping the identity column and losing it completely.

Cheers.

_________________________
- Vijay G
Strive for...
Forum: SQL Server 2000 September 3rd, 2007, 09:19 AM
Replies: 17
Views: 4,623
Posted By happygv
neeloy, Thanks for the update. I understand that...

neeloy,

Thanks for the update. I understand that your approach is to move the data to another column within the same table and then drop the column with Identity set. This is something similar to...
Forum: SQL Server 2005 July 27th, 2007, 03:20 AM
Replies: 4
Views: 748
Posted By happygv
Did you forget the database name there? SELECT...

Did you forget the database name there?
SELECT <LinkServerName>.<DBNAME>.<Owner>.<FunctionName>()

Cheers

_________________________
- Vijay G
Strive for Perfection
Forum: SQL Server 2000 July 27th, 2007, 03:10 AM
Replies: 6
Views: 27,811
Posted By happygv
Did you find the used space using...

Did you find the used space using sp_spaceused?

You can also use
DBCC SHRINKFILE (<logical file name>, <post_shrink_size>)
from query analyser.

Eg: DBCC SHRINKFILE ( 'baselog', 9500 ) -- check...
Forum: SQL Language July 27th, 2007, 03:03 AM
Replies: 3
Views: 1,263
Posted By happygv
Please search on google, you should find a lot. I...

Please search on google, you should find a lot. I need to search into my archive. Will post it here, if I find...

_________________________
- Vijay G
Strive for Perfection
Forum: SQL Server 2000 July 25th, 2007, 07:47 AM
Replies: 6
Views: 27,811
Posted By happygv
Did you find out if there are any free space...

Did you find out if there are any free space (unallocated space) left in the data/log files that can be freed by shrinking? I doubt it doesn't have unallocated space, thus not shrinking beyond 4-5...
Showing results 1 to 25 of 500

 


All times are GMT -4. The time now is 06:13 PM.


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