Search results for query: *

Greetings, I'm trying to write a view that resides in one db1."table" (that doesn't contain the same table as db2) and selects from db2.Lease table. Both db's are in the same SQL Server. I thought I read somewhere that a view you are executing (selecting) from an application had to have reside...

Greetings, I'm pretty slow at SQL for as long as I've been associated with SQL Server. But non the less... I have a query that runs correctly until I attempt to add a group by. I know it must be something not too difficult, but, I'm at a loss. select [Entry No_], [Sale No_], [Posting Date]...

I'm migrating 4 db's off the machine from Hell (development server thrust into production) onto a permanent production sql server on another file server. The current db dbids are in the left column and the new db's dbids to migrate to are in the right column: Asset 7 7 GFPB 10 6...

Hey Everyone, I have an application that I need to install and it hangs at 91% on C:\WINDOWS\Fonts\Tahoma.ttl (I would assume the other Tahoma Bold as well if it gets to it). I was told by the Software manufactuer\distributer to either: 1) Rename them or 2)Delete them. I'm sys admin and I'm...

I need some help designing database tables. I have years of DBA/SA experience, but have tried to stay away from coding, Well life has caught up with me: I have to create a Cell Phone Billing database and have the following general logical design for five tables: BillingCharges (PlanType is a...

I'm sure this obvious but, I'm looking around trying to find info on DTS Designer. Where is it? I can't find any info on how to get it or install it.

I have a problem with migration. Due to issues too complicated (insane) to discuss, the problem is I have to migrate from a first development SQL server (poorly configured by a Web developer) that was turned into a production server. I had to build a new production SQL server on a new file...

Hey everyone, We need to convert text inserted into a form's input field in mixed case (Last Name) into Upper Case for loading into a MS SQL Server 2000 table. The insert already works, we just need to convert the text. Has anyone done this sort of conversion? Thanks in advance, Craig Webber

Hey everyone hope Friday is going well! I have to declare that I am a DBA returning to the field after an 8 year break, and this time I'm trying to learn SQL. I have a problem with this query that we are going to exec from a Web front end to update a site User login/validation table where the...

Greetings, My development partner (Dream Weaver MX 2004) and myself (MS SQL Server) are creating a site phone book and front end for users to manage their own p.book contact information (name, occupation, phone, alt, mobile, fax) and want have the user log into the p.book application, using site...

Greetings Everyone, I have two tables, in two databases on one SQL Server: GFPB.P(HONE)B(OOK)2004 and CELLPHONES. I've been asked to ask to intergrate Cellphone numbers from the two tables, CELLPHONES.Phones into the GFPB.PB2004 table. The table.columns I need to import/intergrate to match...