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 146
Search took 0.01 seconds.
Search: Posts Made By: David_the_DBA
Forum: SQL Server 2000 September 8th, 2006, 04:45 PM
Replies: 6
Views: 1,534
Posted By David_the_DBA
Is there a limit to how many rows might have the...

Is there a limit to how many rows might have the same id value?

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Forum: SQL Server 2005 September 8th, 2006, 04:44 PM
Replies: 1
Views: 1,445
Posted By David_the_DBA
For SQL 2005 it is recommended that you use a...

For SQL 2005 it is recommended that you use a varbinary(max) datatype to store it. You could also use an image data type.

So you can create a table with one of these datatypes and then a...
Forum: SQL Server 2005 September 7th, 2006, 04:30 PM
Replies: 2
Views: 6,220
Posted By David_the_DBA
Several problems: 1) Your key names did not...

Several problems:
1) Your key names did not match
EncryptByAsymKey(AsymKey_ID('Asym_Password')
DecryptByAsymKey(AsymKey_ID('Asym_Looney_Tunes')

2) Your input and output datatypes don't match up...
Forum: SQL Server 2005 September 7th, 2006, 12:35 PM
Replies: 1
Views: 2,102
Posted By David_the_DBA
Here is a little example from BOL from the...

Here is a little example from BOL from the EncryptByKey (Transact-SQL) topic
USE AdventureWorks;
GO

-- Create a column in which to store the encrypted data.
ALTER TABLE HumanResources.Employee...
Forum: SQL Server 2005 August 26th, 2006, 11:49 AM
Replies: 1
Views: 934
Posted By David_the_DBA
There is no SQL Server 2003. There is 2000 and...

There is no SQL Server 2003. There is 2000 and 2005. Post your questions

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Forum: SQL Server 2005 August 26th, 2006, 11:48 AM
Replies: 1
Views: 741
Posted By David_the_DBA
Use Dynamic SQL like this ...

Use Dynamic SQL like this

EXEC(@SomeSQLString)

or
exec sp_executesql

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Forum: SQL Server 2005 August 26th, 2006, 11:46 AM
Replies: 1
Views: 807
Posted By David_the_DBA
Very few people are migrating backwards but you...

Very few people are migrating backwards but you could try scripting out your database and then running the script in SQL 2000. You will encounter some errors but you should be able to work through...
Forum: SQL Server 2005 August 26th, 2006, 11:44 AM
Replies: 2
Views: 745
Posted By David_the_DBA
Based on your datatypes I would have to say that...

Based on your datatypes I would have to say that you are using ACCESS rather than SQL Server.

Next, if I understand your schema correctly you are violating 1st Normal Form and that is causing your...
Forum: SQL Server 2005 July 28th, 2006, 10:43 AM
Replies: 1
Views: 14,015
Posted By David_the_DBA
There are a lot of new features for performance,...

There are a lot of new features for performance, easier coding, can write stored procedures, views, udfs, triggers, udts in C# or VB.NET, better XML functionality, new services, better high...
Forum: SQL Server 2005 July 28th, 2006, 10:33 AM
Replies: 2
Views: 3,825
Posted By David_the_DBA
-- Foreign Key Example ALTER TABLE...

-- Foreign Key Example
ALTER TABLE Sales.ContactCreditCard
NOCHECK CONSTRAINT FK_ContactCreditCard_Contact_ContactID
-- Check Constraint Example
ALTER TABLE Person.Contact
NOCHECK CONSTRAINT...
Forum: SQL Server 2000 July 23rd, 2006, 01:09 PM
Replies: 3
Views: 746
Posted By David_the_DBA
Here is an example that will work for multi row...

Here is an example that will work for multi row as well as single row inserts
CREATE TABLE tbl_01 ( id int , name varchar(20))
go

CREATE trigger trg_01 on tbl_01 instead of insert
as
UPDATE...
Forum: SQL Server 2000 July 23rd, 2006, 01:02 PM
Replies: 1
Views: 776
Posted By David_the_DBA
Vinod, The best way to tell is to execute both...

Vinod,
The best way to tell is to execute both queries in Query Analyzer with Show Execution plan turned on.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Forum: SQL Server 2000 July 23rd, 2006, 12:59 PM
Replies: 1
Views: 1,464
Posted By David_the_DBA
Use query analyzer to see what execution plan is...

Use query analyzer to see what execution plan is being used when executing these procs against the new database.

If it uses scans instead of seeks it may be that your statistics are out of date....
Forum: SQL Server 2000 July 23rd, 2006, 12:55 PM
Replies: 3
Views: 1,179
Posted By David_the_DBA
Yes you can, if it was implemented in the Stored...

Yes you can, if it was implemented in the Stored Proc. However, stored procs that call sp_OA procs are going to be far less efficient than an XP where you make one call to it.
Take a look at...
Forum: SQL Server 2000 July 23rd, 2006, 12:52 PM
Replies: 1
Views: 2,759
Posted By David_the_DBA
Take a look at this...

Take a look at this http://www.sqldev.net/xp/xpsmtp.htm
This XP has been used by many and is well tested.


David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Forum: SQL Server 2000 July 23rd, 2006, 12:49 PM
Replies: 3
Views: 910
Posted By David_the_DBA
Imar, Don't you have the telepathic english...

Imar,

Don't you have the telepathic english query driven schema reader?

Anshul posted this to the 2005 board as well. I told him to use Profiler to observe what happens when a survey is...
Forum: SQL Server DTS July 23rd, 2006, 12:46 PM
Replies: 3
Views: 1,615
Posted By David_the_DBA
Is this DTS or SSIS? Post your file schema (a...

Is this DTS or SSIS?
Post your file schema (a few example lines).
If DTS, I presume you are using a Data pump task and the destination is SQL Server.
Give a little more info please

David...
Forum: SQL Server 2005 July 23rd, 2006, 12:45 PM
Replies: 2
Views: 1,229
Posted By David_the_DBA
Are you using Access data Projects (ADP) or MDB...

Are you using Access data Projects (ADP) or MDB files?
IF ADP's then you should be aware that Access 2000 adp's were not designed for SQL 2000 let alone 2005.

You have already identified a...
Forum: SQL Server 2005 July 23rd, 2006, 12:39 PM
Replies: 1
Views: 799
Posted By David_the_DBA
Use SQL Profiler to see what SQL statements the...

Use SQL Profiler to see what SQL statements the client software is issuing when the user submits a survey.

None of us know what survey software you have (off the shelf or custom) and so none of us...
Forum: SQL Server 2000 July 12th, 2006, 08:53 AM
Replies: 2
Views: 6,563
Posted By David_the_DBA
FROM BOL Using Microsoft Internet Information...

FROM BOL
Using Microsoft Internet Information Services and Indexing Service for File Content Searches
"Noise Words
Noise-word lists for many languages are provided and the set of supported...
Forum: SQL Server DTS May 29th, 2006, 05:39 PM
Replies: 2
Views: 2,519
Posted By David_the_DBA
I assume this is DTS on SQL 2000. In any...

I assume this is DTS on SQL 2000.

In any event, has CuteFtpPro been installed on the SQL Server?

When you run the package by hand you are running the package on the machine where you are logged...
Forum: SQL Server 2000 May 29th, 2006, 05:35 PM
Replies: 5
Views: 1,850
Posted By David_the_DBA
VPN is much safer! David Lundell Principal...

VPN is much safer!

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Forum: SQL Server 2000 May 29th, 2006, 05:33 PM
Replies: 14
Views: 2,807
Posted By David_the_DBA
Sorry joxa83 -- I must have misunderstood the...

Sorry joxa83 -- I must have misunderstood the problem. You could call it from a client app, get the second result set and then insert that data into a table.

David Lundell
Principal Consultant...
Forum: SQL Server 2000 May 26th, 2006, 08:04 AM
Replies: 14
Views: 2,807
Posted By David_the_DBA
CREATE TABLE #FileList (Files varchar(8000)) ...

CREATE TABLE #FileList (Files varchar(8000))
INSERT #FileList (Files)
EXEC master.dbo.xp_cmdshell 'dir c:\'

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Forum: SQL Server 2000 May 22nd, 2006, 05:47 PM
Replies: 6
Views: 2,178
Posted By David_the_DBA
Open Computer manager Go to Services Double...

Open Computer manager
Go to Services
Double click on the SQL Server Service
click on the Logon Tab. Post back to the forum what it says.

If it says local system, then switch to a domain user.
...
Showing results 1 to 25 of 146

 




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