Search Results

Search found 28140 results on 1126 pages for 'pl sql'.

Page 50/1126 | < Previous Page | 46 47 48 49 50 51 52 53 54 55 56 57  | Next Page >

• Tune SQL Server Express using Profiler?

  - by Glen Little

  I have a SQL Server 2005 database... a copy of it is running in development on a full version of SQL server. Another copy is running in SQL Server 2005 Express on a web server. I've used SQL Profiler and saved a Tuning trace log from activity on the SQL Express copy of the database. I want to use the saved trace log in the Database Engine Tuning…

  Read the article

• SQL server 2008 R2 installation error

  - by Sonia

  I have a windows 7,32 bit laptop. I am the administrator with all permissions. when I click on the SQL server 2008R2 set up file,it says : "SQL server set up has encountered the following error:Failed to retreive data for this request" click on OK. I have uninstalled all the components of SQL from control panel. I used Windows installer clean up…

  Read the article

• Tune SQL Server Express using Profiler?

  - by Glen Little

  I have a SQL Server 2005 database... a copy of it is running in development on a full version of SQL server. Another copy is running in SQL Server 2005 Express on a web server. I've used SQL Profiler and saved a Tuning trace log from activity on the SQL Express copy of the database. I want to use the saved trace log in the Database Engine Tuning…

  Read the article

• cannot at all find sql instance (while installing an asp.net app on IIS)

  - by giddy

  So I'm really not a DBA, I'm an app dev. I had to install my asp.net mvc3 app on my client's(a large company) IIS6 + Win2k3 machine, with absolutely no help from their sysadmins. The final problem now is SQL Server 2008 r2, after figuring out how to create a login from windows, my app and sqlcmd.exe always complains it cannot find a sql server…

  Read the article

• SQL ERROR: Verify that the instance name is correct and that SQL Server is configured to allow remote connections?

  - by scepak

  I am getting following error while connecting to my local Sql Express. An error has occurred. Details of the exception: A network-related or instance-specific error occurred while establishing a conne ction to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured…

  Read the article

• SQL Server Intellisense VS. Red Gate SQL Prompt

  Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database…

  Read the article

• Problems installing SQL Server 2008 on Windows 7 Pro

  - by Trindaz

  I'm having no luck. I've tried installing SQL Server 2008 Express on my Windows 7 Pro box about 4 times now. Each time it installs the 'setup files required' then does nothing. All I can do is click the 'New ... or Add Features...' link to try starting again but get the same results each time. Any developers experienced this before?

  Read the article

• verbose error information for MS SQL Server bulk insert

  - by TheObserver

  I'm using SQL Server 2008 Express and I'm doing a bulk insert of data. I'd like to have more verbose error messages, ideally printing the data that failed to be inserted. Is that possible?

  Read the article

• How can I disable the windows authentication mode of SQl Server

  - by Azhar

  How can I disable the windows authentication mode of SQl Server and restrict it to ask for user and Password every time and no windows authentication. for security purposes

  Read the article

• DBCC SQL Server 2000 sysindexkeys

  - by Debasish Pramanik

  I have a SQL Server 2000 database. When I run the following command select * from sysindexkeys This display the appropriate records. I then do a DBCC command for the sysindexkeys. It doesn't display anything. Strange there is no page having the sysindexkeys records. Then how the query display the list of records.

  Read the article

• SQL select statement filtering

  - by cc0

  Ok, so I'm trying to select an amount of rows from a column that holds the value 3, but only if there are no rows containing 10 or 4, if there are rows containing 10 or 4 I only want to show those. What would be a good syntax to do that? So far I've been attempting a CASE WHEN statement, but I can't seem to figure it out. Any help would be…

  Read the article

• SQL Server - OPENXML how to get attribute value

  - by DotnetDude

  I have the following XML: <Field FieldRowId="1000"> <Items> <Item Name="CODE"/> <Item Name="DATE"/> </Items> </Field> I need to get the FieldRowId using OPENXML. The SQL i have so far: INSERT INTO @tmpField ([name], [fieldRowId]) SELECT [Name], --Need to get row id of the…

  Read the article

• CHECK/NOCHECK for Sql Compact Edition

  - by Ryan H

  I am attempting to wipe and repopulate test data on SQL CE. I am getting an error due to FK constraints existing. Typically in Sql2005 I would ALTER TABLE [tablename] CHECK/NOCHECK CONSTRAINT ALL to enable/disable all constraints. From what I could find in my searching, it seems that this might not be supported in CE. Is that true? If…

  Read the article

• Moving data from SQL Compact to SQL Server 2008

  - by Ashok

  I have created an .SDF file and inserted data into the SDF database file on a mobile device. I want to transform .SDF file to a SQL Server 2008 Database File but don't know how. Any pointers or suggestions would be appreciated.

  Read the article

• SQL update query using joins

  - by Shyju

  I have to update a field with a value which is returned by a join of 3 tables. Example: select im.itemid ,im.sku as iSku ,gm.SKU as GSKU ,mm.ManufacturerId as ManuId ,mm.ManufacturerName ,im.mf_item_number ,mm.ManufacturerID from item_master im, group_master gm, Manufacturer_Master mm where …

  Read the article

• Best optimizing for a large SQL Server table (100-200 Mil records)

  - by RPS

  What are the best options/recommendations and optimizations that can be performed when working with a large SQL Server 2005 table that contains anywhere from 100-200 Million records?

  Read the article

• Create a DB alias using T-SQL in SQL Server 2005

  - by Randall Salas

  Hi: I am trying to create a Database alias for many of the DBs. I wonder if there is a T-sql that can let me do it. I have not found anything about this. Thx.

  Read the article

• Creating SQL table using Dynamic variable name

  - by megatoast

  I want to create backup SQL tables using variable names. something along the lines of DECLARE @SQLTable Varchar(20) SET @SQLTable = 'SomeTableName' + ' ' + '20100526' SELECT * INTO quotename(@SQLTable) FROM SomeTableName but i'm getting Incorrect syntax near '@SQLTable'. It's just part of a small script for…

  Read the article

• How can I get a SQL Server 2005 compatible backup from SQL Server 2008 database?

  - by masoud ramezani

  I have a sql server 2008 db, I want to restore its backup to a 2005 version. Is there any way for this work?

  Read the article

• Linq To Sql - SQL Default Constraint Problem

  - by Ahmet Altun

  I have a USER table in database. The table has a RegistrationDate column which has a default constraint as GETDATE(). When using LINQ, I don't provide any data for RegistrationDate column to make it default. But SQL Server raises error. I think LINQ tries to insert NULL into the column. How can I make LINQ not to try to…

  Read the article

• SQL error with script to create

  - by PapaDaniel

  I used the SQL Server management studio on a table with Create Script to New and did minor changes. Give me an error "Incorrect syntax near '('" for the "(" after "WITH" /* EventType Table Creation */ CREATE TABLE [EventType] ( [pkEventID] [int] IDENTITY(1,1) NOT NULL, [Description] [nvarchar](50) NOT NULL, …

  Read the article

• How to install SQL Server 2005 Express with pre-existing SQL Server 2008

  - by salvationishere

  I have a 32-bit XP with VS 2008 and SQL Server 2008, both Full and Express databases. I am trying to install SS 2005 Express and I get errors when I do saying that 2008 Express is a newer version. How do I uninstall 2008 Express?

  Read the article

• DataTable not auto incrementing when database changed to SQL server 2008

  - by Rigobert Song

  I have scripted my SQL server 2000 database and created it on a 2008 server. I update the database using a ADO .Net Dataset designed in VS 2003. My problem is certain tables that have identity fields don't have these fields as auto increment in the dataset? I could set these to auto increment in code, but this…

  Read the article

• Do Instances Share Same Services? - SQL Server

  - by peace

  Lets say i installed two named SQL Server 2008 instances e.g. A and B, will i have two services of each type e.g. two analysis service, two reporting service and so on, one service for A and the other for B? If yes, then it is known a service listens on a port number, how two same services going to listen on the…

  Read the article

• Getting date string from getdate method

  - by Muhammad Akhtar

  Hi, I need date string using sql statement like.. select getDate() this will return 2010-06-08 16:31:47.667 but I need in this format 201006081631 = yyyymmddhoursmin How can I get this? Thanks

  Read the article

< Previous Page | 46 47 48 49 50 51 52 53 54 55 56 57  | Next Page >