Programming SQL

Spy Video Eyewear Recorder EVR130 available at http://www.gusdeluxe.info/Catalog
Eyewear Spy Video Recorder EVR130 http://www.gusdeluxe.info/Catalog/video-eyewear-recorder-evr130-p-342.html 1. Quality Polaroid Lens from brand makers. 2. 1.3 mega pixels pinhole CMOS camera for clear digital recording. 3. User friendly operation button for easy control. 4... 24 Jul 2008 14:58

rewrite this to be a join, not a subquery
Hi. I've got a select statement that uses an aggregate clause nested inside of a subquery. For my own edification (as well as taking advantage of any available performance boosts that come with it), I'd like to know how to rewrite it so it doesn't have a subquery. Here's the statement: --------------- SELE... 24 Jul 2008 20:07

MS SQL 2005 Certification Dumps
Hi, Pelase find the MS SQL 2005 Certification Dumps at http://itjobguru.com/forum/viewtopic.php?f=54&t=351 Regards, Naveen ... 24 Jul 2008 14:58

What are the limits to scaling Sql Server Database using Distribut
As for how many servers may be included in a distributed view before performance issues start emerging, I expect it would depend on how many servers a single query will span. Generally speaking, when you examine the execution plan, you will find that SQL Server is smart enough to only select from a single serve... 24 Jul 2008 14:58

Is there a way to grant users to view stored procedures.
Hi, Does anyone knows if there is a way to grant users view stored procedures. I am using SQL 2005. Thanks in advance. I got an errors and not sure if it's the correct syntax: GRANT VIEW DEFINITION ON SCHENA:dbo TO [CompDomain\BizTlkAdmin] GO ... 24 Jul 2008 14:58

EPOCH DateTime Conversion >= 4 days
Hello again, Okay, so it's been nearly a year since inquiring. I'm now curious about getting results from the previous day - just that day only. As always, your help is appreciated. Marc From http://www.developmentnow.com/g/113_2007_7_0_0_1000767/EPOCH-DateTime-Conversion-4-days.htm Posted via DevelopmentNo... 25 Jul 2008 10:26

Where to put Stored Procedures in SQL 2005
I'm trying to save a SP into the DB but it's asking me for a location. I'm doing this in SQL Mgmt Studio. This is my first SP from Mgmt Studio. I don't want the SP to be a file. I want it in the DB. ... 25 Jul 2008 07:21

Changing table ownership
Hello, I need to change table ownership - but am being told schemas have to be changed in SQL 2005. Now seeing an error: Invalid object name 'dbo.address1'. Currently that table is called 'admin.address1' So I thought changing the ownership would do it I found this on the web: ALTER SCHEMA dbo TRANSF... 24 Jul 2008 13:56

SSIS & Code pages
Sorry for the cross post. I originally posted this in the wrong NG. I've been working on setting up a package to simply append data into a table residing in a 2005 db. (I've even tried importing the flat file from management studio) I continue to get this error, regardless of how I structure the target table.... 24 Jul 2008 14:58

Querying Active Directory from SQL server 2005
Hi all, I am trying to query my AD so I can import them into a sharePoint Org Chart. Can anyone tell me what I did wrong with my linked server to AD? I Linked to AD using: sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource' then I tried to run: select * from... 21 Aug 2008 12:27