Microsoft SQL Server

• Microsoft SQL Server Questions

• • BLOB, Files & T-SQL

    Hi guys,I'm quite new with MS-SQLServer and I wondering if there's a way to do the following...

    By madmax

  • Data Migration

    Hi I have a DTS Package with which I am migrating data from One SQL Server Database to Another. As ...

    By charugupta

  • Data mapping error in XSD

    Here is my snippet of XML I'm trying to import into a SQL table:<clicks><clickdate>8/14/...

    By the_guapo

  • Extol Chooses Yellowfin Business Intelligence for ...

    Yellowfin has announced a new partnership with Extol, one ofMalaysia's largest ICT security solution...

    By yellowfinannouncements

  • Recognition of Cube in Catalog

    We have an application that uses MSADOMD classes to access Cubes in a catalog. There are total of 4 ...

    By maruti

• • Extra "blanks" in the cloumn field

    When I enter a data in a table, SQL Server automatically completes the data with blanks up to lengt...

    By recepbala, 2 Comments

  • Data manipulation

    I have a table which contains the following data: 1877: Morell, Prince Edward Island 1878: Morin...

    By u_t_a, 3 Comments

  • Block remote login

    How can I block users from using their SQL accounts to access SQL 2000 serverremotely thru enterpris...

    By benny, 1 Comments

  • SQL Attached mdf database files VS database import...

    Hi all(newbie @ asp.net)(oldie @ ASP 3)What is the purpose of using an attached MDF database files i...

    By wstevens_vodamail_co_za, 2 Comments

  • How to make Update relation?

    I have two tables: TableX & TableYthere is two similar fields (Size) with the same datatype, I w...

    By hsbflewe, 2 Comments

• Microsoft SQL Server: is the Category's subject.It's has 265 questions,this is No.14 pages.
• How to manage click-through
• How will I possibly do click through on this type of chart when basically I'll have to bring in just Grand Total values to do what they want to do here in this mock-up: SSRS 2005 Expected/Desired Outcome (user drew this using Excel and later wants click-through capability through SSRS 2005 ...
• favorflave, Mon, 15 Mar 2010 10:34:00 GMT, 954 bytes, 2 Answer
• Oracle and unicode
• Since the .net oracle providers are the only ones that work in x64 it is extremely annoying that it insists on mapping ALL varchar columns in oracle to wstring. Is there a way to fix this? The oledb providers don't have this problem but I don't like being forced to use the 32 bit runtime as a ...
• brentmills, Mon, 15 Mar 2010 04:55:00 GMT, 307 bytes, 3 Answer
• Reclaiming space on my harddrive after a mass delete.
• I deleted about 20 million rows out of my DB that had about 200 million rows.I expected that I would regain diskspace when showing the properties of thatdrive, but the disk was not reclaimed. Do I need to shrink that DB in orderto see how much actual space has been reclaimed, or do I need to do...
• steveb, Sun, 14 Mar 2010 18:27:00 GMT, 457 bytes, 3 Answer
• Data Mart Maintenance
• The database maintenance on our data mart SQL server is causing problems.The re-index process causes too much file growth and the processes are unable to complete due to disk space constraints.I want to write a process to re-index the database, but handle this a single file group at a time and ...
• chip_levis, Sun, 14 Mar 2010 13:27:00 GMT, 707 bytes, 1 Answer
• Data migration MSDE -> SQL Compact
• Hi allCurrently we are using the MSDE as SQL Server and decide to switch to use the smaller and file based SQL Server 2005 Compact Edition.Because of update issue we need to merge data from an already installed database into the new compact edition. Are there some tools we could use in our ...
• danielwiss, Sun, 14 Mar 2010 11:14:00 GMT, 428 bytes, 2 Answer
• M.I'5.Persecu tion ` Capit al Radio - C hris Tarran t
• -=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-= Capital Radio -. Chris Tarrant -=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=Capital Radio DJs. have been "in on it" from the start. One of the firstthings I heard in the summer of 1990 was from a Capital DJ who. said, "Ifhe listens to Capital then he can't. be a...
• vmimfemvm_bigfoot_com, Sat, 13 Mar 2010 20:27:00 GMT, 2,147 bytes
• Blobs in SQL
• Can anyone tell me what the pros/cons are of using blobs in sql?We are looking at scanning certain paperwork and storing it with theappropriate records in our database. The two options are to store the imagesas blobs or to store them as file system objects with a referral pointer inthe db.I have...
• jawallaby, Sat, 13 Mar 2010 03:46:00 GMT, 493 bytes, 3 Answer
• Block access to system objects & system stored procedure
• Dear Sir/Madam,Is there any convenience ways to block a list of users account from accessto system objects e.g. sysobjects, syscomments etc and disallow them to callstored procedure e.g. sp_help etc.My objective is to restrict the access to those applications account inorder to prevent hakers to...
• henry, Sat, 13 Mar 2010 03:42:00 GMT, 394 bytes
• Oracle 9i Drivers for Link Server?
• Hi All,I have a SQL Server 2000 and need to create a Link Server to an Oracle 9idatabase to get at stored procs. I am having a devil of a time trying tofind the correct Oracle drivers to place on my SQL Server. Can anyonedirect me to the correct drivers please.Thanks,John....
• john, Sat, 13 Mar 2010 03:37:00 GMT, 309 bytes, 1 Answer
• Recommendation Requests: Learning MS SQL Server for Sybase DBAs
• Hello,I have been working as Sybase DBA for 5+ years, and I would very much like to add MS SQL Server to my resume. Given the common roots of the two RDBMS, it seems that the learning curve would not be as sharp as if I were going to learn Oracle or DB2. Can anyone out there know of any books...
• zremdog, Sat, 13 Mar 2010 03:37:00 GMT, 426 bytes, 3 Answer
• M`I,5.Pe rsecution . harass ment at w ork
• -=-=-=-=-=-=-=-=-=-=-=-=-= harassment. at work -=-=-=-=-=-=-=-=-=-=-=-=-=Once I stopped watching television and listening to. the radio at the end of1990, "they" had to find other ways of. committing abuses. So they took whatmust be for them a tried and tested route; they get. at you by subversi...
• iefmfi_gmail_com, Sat, 13 Mar 2010 03:36:00 GMT, 2,447 bytes
• SQL Audit
• HiI have been asked to look into getting a SQL Audit application to view whochanged what data, from what workstation and the date and time it waschanged.Apex SQL Audit seems to be the only tool i can find for the job. I wouldlike to compare this with another application. Does anyone have anyreco...
• james, Sat, 13 Mar 2010 03:34:00 GMT, 376 bytes, 3 Answer
• '' The definition of object [object name] has changed since it was compiled'' error when alt
• Hello All Not sure if this is the right forum to post this question to, so if it's not, please accept my apologies. I'm working in SQL Server 2005 with a database that was migrated to 2005 from SQL Server 2000. I have to alter a trigger on a table for some functionality changes, and when I ...
• jay_at_work, Fri, 12 Mar 2010 12:14:00 GMT, 1,426 bytes, 3 Answer
• behind the 8 ball !
• THIS IS ABSOLUTELY LEGAL!!!!!You are requesting a legitimate service and you are paying for it!!Like most of us I was a little skeptical and little worried about the legalaspects of it all. So I checked it out with theU.S. Post Office (1-800-238-5355)and they confirmed that it is indeed legal!!M...
• poolsharks, Fri, 12 Mar 2010 03:00:00 GMT, 6,159 bytes
• Oracle 9i Database Administration in 10 Minutes
• The Topics Covered In This Book Are: Understanding the OracleEnvironment; Understanding the Oracle Instance; Understanding theworking of Oracle Instance; Understanding the Oracle Database; Oracle9i Software Installation; Oracle 9i Database Design using DBCA;Enabling other computers to access Ora...
• takveen_gmail_com, Fri, 12 Mar 2010 02:05:00 GMT, 1,069 bytes, 1 Answer
• data mapping and migration
• Has anyone used DTS packages for migrating old data to a new schema?If so are there any tutorials on this?I'd prefer not to do this by hand. ;-)...
• chopps, Fri, 12 Mar 2010 00:45:00 GMT, 155 bytes, 3 Answer
• Oracle as a linked server
• Does anyone know if Microsoft officially supports Oracle 9i as a linkedserver ?Thanks very much,Natasa...
• natasa, Thurs, 11 Mar 2010 23:31:00 GMT, 126 bytes, 1 Answer
• SQL ASP Update Problem
• Hi GuysI have trouble updating the existing records, following is the code I'm using myconnection.Open() Dim myCommand As SqlCommand Dim sqlUpdate As String sqlUpdate = "update registeredmembers set FirstName='" + txtUserName.Text "',"......... Try...
• vishy8015, Thurs, 11 Mar 2010 23:29:00 GMT, 1,434 bytes, 2 Answer
• How to make this query...
• Hi all. I have tried making this query for a while and i didn't manage to. I know it is something related to JOIN, but i didn't manage to make it work :\ I have two tables. Table1- db_stockprices Table2- db_stockSymbols db_stockprices is getting updated every day with stock daily ...
• raindm, Thurs, 11 Mar 2010 23:03:00 GMT, 8,421 bytes, 11 Answer
• How to make UDF deterministic
• How to make UDF deterministic I have a user defined function in SQL Server 2000 that splits a Name field into First, Last, Middle names. Originally I utilized the CHARINDEX function to find the spaces in the string. Since I then found out that function is by definition Non-deterministic that did...
• olichap, Thurs, 11 Mar 2010 17:14:00 GMT, 2,324 bytes
• «««4567891011121314