Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | 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 57
Search took 0.01 seconds.
Search: Posts Made By: agossage
Forum: SQL Server 2005 April 13th, 2007, 08:13 PM
Replies: 2
Views: 1,591
Posted By agossage
There are many possible issues. Try to force...

There are many possible issues.

Try to force Named Pipes...
NP:SV-01-SQL01\SQL2000

Try to force TCP/IP...
TCP:SV-01-SQL01\SQL2000 (dynamic port determination)
TCP:SV-01-SQL01\SQL2000,<port...
Forum: SQL Server 2005 April 12th, 2007, 09:09 AM
Replies: 1
Views: 995
Posted By agossage
The full backup does not back up the log. You...

The full backup does not back up the log. You will need another task to handle the log file.

Depending the catalog usage, you should backup the log file periodically throughout the day. As usage...
Forum: SQL Server 2005 April 11th, 2007, 12:54 PM
Replies: 2
Views: 1,068
Posted By agossage
Try putting parenthesis around the select...

Try putting parenthesis around the select statement, like...
SELECT
c.LastName
, ISNULL(CAST((SELECT MIN(OrderDate) FROM Sales.SalesOrderHeader o WHERE o.ContactID = c.ContactID) AS varchar), '...
Forum: SQL Server 2005 April 7th, 2007, 08:37 AM
Replies: 3
Views: 4,001
Posted By agossage
Another possibility, you can find in the...

Another possibility, you can find in the ERRORLOG, shared memory is not enabled or working correctly.
Look for the line(s)... (this shows that shared memory is listening)
Server local connection...
Forum: SQL Server 2005 April 7th, 2007, 08:32 AM
Replies: 3
Views: 4,001
Posted By agossage
Don't worry too much about remote connections...

Don't worry too much about remote connections unless you want to use TCP/IP or Named Pipes. When connecting locally, shared memory will be used unless a specific protocol has been specified.

The...
Forum: SQL Server 2005 April 7th, 2007, 08:08 AM
Replies: 2
Views: 754
Posted By agossage
http://www.microsoft.com/downloads/details.aspx?Fa...

http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

In the future, visiting the Microsoft web site will point you in the right direction.
...
Forum: SQL Server 2005 April 6th, 2007, 09:25 PM
Replies: 2
Views: 3,197
Posted By agossage
You can only change the server collation by...

You can only change the server collation by issuing a reinstall. Review the BOL... ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/3242deef-6f5f-4051-a121-36b3b4da851d.htm

If you don't mind the...
Forum: SQL Server 2005 April 6th, 2007, 08:55 PM
Replies: 5
Views: 748
Posted By agossage
Not passing a value for the FinancialID_One...

Not passing a value for the FinancialID_One column is the issue. Without knowing the datatype of the FinancialID_One column, I am not sure what value to pass in the example.

Possible example......
Forum: SQL Server 2005 April 1st, 2007, 08:35 PM
Replies: 3
Views: 529
Posted By agossage
In Management Studio, connect to server name...

In Management Studio, connect to server name .\SQLEXPRESS

Adam Gossage
Lake Wylie, SC, USA
Forum: SQL Server DTS March 29th, 2007, 01:26 PM
Replies: 3
Views: 1,756
Posted By agossage
When you say that they run them manually and they...

When you say that they run them manually and they work, are you running them on your local machine or on the server via RDP/console? You will want to check that the server has the ODBC DSN and...
Forum: SQL Server DTS March 29th, 2007, 12:20 PM
Replies: 3
Views: 1,756
Posted By agossage
What error message do you get? Does the package...

What error message do you get? Does the package have a connectivity issue or ???

Adam Gossage
Lake Wylie, SC, USA
Forum: SQL Server 2005 March 28th, 2007, 04:14 PM
Replies: 2
Views: 726
Posted By agossage
Each user will get there own user instance set of...

Each user will get there own user instance set of system databases when they connect for the first time and the User Instance option is set to True.

Since the system databases are copied locally...
Forum: SQL Server 2000 March 28th, 2007, 03:58 PM
Replies: 4
Views: 968
Posted By agossage
A DEFAULT CONSTRAINT is useful when no value is...

A DEFAULT CONSTRAINT is useful when no value is supplied for the given column. By 'no value', I do not mean NULL. NULL is a value.

If the app or user supplies a value that is unacceptable and...
Forum: SQL Server 2005 March 28th, 2007, 03:40 PM
Replies: 1
Views: 699
Posted By agossage
If a valid value for the column is NULL, then set...

If a valid value for the column is NULL, then set NULL to checked to allow for NULLs.
If the only valid values for the column are keyed in another table, then set NULL to unchecked to disallow...
Forum: SQL Server 2000 March 27th, 2007, 09:59 AM
Replies: 1
Views: 1,275
Posted By agossage
From the 2000 BOL... xp_sendmail Sends a...

From the 2000 BOL...

xp_sendmail
Sends a message and a query result set attachment to the specified recipients.

Syntax
xp_sendmail {[@recipients =] 'recipients [;...n]'}
[,[@message =]...
Forum: SQL Server 2000 March 23rd, 2007, 07:32 AM
Replies: 2
Views: 841
Posted By agossage
I made some assumptions due to other possible...

I made some assumptions due to other possible requirements that you didn't supply or where in error.
Are the field1 values really just two possible values?
Resultset??
id tableaid field1 ...
Forum: SQL Server 2005 March 22nd, 2007, 02:50 PM
Replies: 1
Views: 2,188
Posted By agossage
It looks like someone received an answer from MS....

It looks like someone received an answer from MS.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=196509&SiteID=1
Read thread 25 Jan 2006, 9:47 AM UTC

Adam Gossage
Lake Wylie, SC, USA
Forum: SQL Server 2005 March 22nd, 2007, 02:38 PM
Replies: 1
Views: 2,282
Posted By agossage
It's possible. I think you would have to have...

It's possible. I think you would have to have serious resource issue for auto close to manifest an issue.

If the database has been closed, no users are logged in, the timeout for auto close has...
Forum: SQL Server 2005 March 22nd, 2007, 02:23 PM
Replies: 1
Views: 1,374
Posted By agossage
You should try to backup and restore from 2000 to...

You should try to backup and restore from 2000 to 2005. This will provide the least resistant path.

In my mind, all other options require extra work. Scripting the objects is not an issue. ...
Forum: SQL Server 2005 March 22nd, 2007, 01:45 PM
Replies: 2
Views: 1,245
Posted By agossage
FYI... C# questions need to go to [P2P Forum]\[C#...

FYI... C# questions need to go to [P2P Forum]\[C# C++]

Adam Gossage
Lake Wylie, SC, USA
Forum: SQL Server 2005 March 22nd, 2007, 01:44 PM
Replies: 2
Views: 1,245
Posted By agossage
According to...

According to http://msdn2.microsoft.com/en-us/library/5724t6za(vs.80).aspx...

<article segment>
Visual C# Reference: Errors and Warnings
Compiler Error CS0236
Error Message
A field...
Forum: SQL Server 2005 March 22nd, 2007, 01:21 PM
Replies: 4
Views: 502
Posted By agossage
Without working with your database in both...

Without working with your database in both environments, I am not sure why you are seeing different results after upgrading to SP2.

The two queries your posted will yield different results for a...
Forum: SQL Server 2005 March 22nd, 2007, 01:11 PM
Replies: 4
Views: 502
Posted By agossage
Due to logical operator order of operations, it...

Due to logical operator order of operations, it would make sense that under certain conditions the two queries would yield different results. I am trying to come up with a simple repro to demostrate...
Forum: SQL Server 2005 March 21st, 2007, 08:44 AM
Replies: 1
Views: 1,032
Posted By agossage
What is the exact error message? That will help...

What is the exact error message? That will help narrow down the issue.

Quite possibly a security issue...
There are three groups that are default logins after installation that the 'users' need...
Forum: SQL Server 2000 March 21st, 2007, 08:38 AM
Replies: 11
Views: 3,681
Posted By agossage
I feel like trying to read minds today...since I...

I feel like trying to read minds today...since I have a handy magic 8 ball.

Assuming the table contains many [userarea]s for a given [name]...
Would this get it done?

<script>
SET...
Showing results 1 to 25 of 57

 


All times are GMT -4. The time now is 10:37 PM.


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