Search Results

Search found 59456 results on 2379 pages for 'sql string'.

Page 76/2379 | < Previous Page | 72 73 74 75 76 77 78 79 80 81 82 83  | Next Page >

• Alter Stored Procedure in SQL Replication

  - by Refracted Paladin

  How do I, properly, ALTER a StoredProcedure in a SQL 2005 Merge Replication? I just need to add a Column. I already successfully added it to the Table and I now need to add it to a SP. I did so but now it will not synchronize with the following error -- Insert Error: Column name or number of supplied values does not match table definition. (Source: MSSQLServer, Error number: 213)

  Read the article

• SQL Server Management Studio Color Schemes?

  - by sunpech

  Is there a way to apply color schemes and themes to SQL Server Management Studio? I really enjoy the ones for Visual Studio 2005/2008/2010 and would love to have something like that. Color Schemes for Visual Studio: Create and share Visual Studio color schemes

  Read the article

• Microsoft SQL Server 2008 R2 release date

  - by abatishchev

  Is there any new information about Microsoft SQL Server 2008 R2 release date? Will it be in April with Visual Studio 2010 release on in May separately?

  Read the article

• Generating the SQL query plan takes 5 minutes, the query itself runs in milliseconds. What's up?

  - by TheImirOfGroofunkistan

  I have a fairly complex (or ugly depending on how you look at it) stored procedure running on SQL Server 2008. It bases a lot of the logic on a view that has a pk table and a fk table. The fk table is left joined to the pk table slightly more than 30 times (the fk table has a poor design - it uses name value pairs that I need to flatten out. Unfortunately, it's 3rd party and I cannot change it). Anyway, it had been running fine for weeks until I periodically noticed a run that would take 3-5 minutes. It turns out that this is the time it takes to generate the query plan. Once the query plan exists and is cached, the stored procedure itself runs very efficiently. Things run smoothly until there is a reason to regenerate and cache the query plan again. Has anyone seen this? Why does it take so long to generate the plan? Are there ways to make it come up with a plan faster?

  Read the article

• Database-independant SQL String Concatenation in Rails

  - by Craig Walker

  I want to do a database-side string concatenation in a Rails query, and do it in database-independent way. SQL-92 specifies double-bar (||) as the concatenation operator. Unfortunately it looks like MS SQL Server doesn't support it; it uses + instead. I'm guessing that Rails' SQL grammar abstraction has solved the db-specific operator problem already. If it does exist, how do I use it?

  Read the article

• SQL commands when SQL only exists on network

  - by chama

  I'm trying to find a list of all sql servers on the network using the osql -L command in the command prompt. This command only works when SQLServer is installed on the computer that I'm working on. Is there any way to run this command when SQLServer is not installed on that particular computer, but is installed somewhere on the network? Thank you! EDIT: I'm writing a program in java, so the easy enumerations that you can do in the .NET framework won't work for me.

  Read the article

• SQL Server 2000/2005 query list user access

  - by Danilo Brambilla

  Hi, is there a query to list database user access and related source IPs on SQL Server 2000 and 2005? Please note that reporting service is not installed. Thank you all for help.

  Read the article

• Select Distinct/Unique Rows from a Huge Table in SQL Server Without Timeout Errors

  - by Maxim Z.

  I have a table in SQL Server with around 400,000 rows. Unfortunately, this table has many duplicate rows, as there isn't a primary key. I'm using SELECT DISTINCT to get all unique rows, but as there's so many of them, I keep getting timeout errors. What's the best way to approach this problem?

  Read the article

• How to find string elements in another string and remove them in PHP

  - by Behrang

  By example: FirstString='apple,gold,nature,grass,class' SecondString='gold,class' the Result must be : ResultString='apple,nature,grass'

  Read the article

• SQL Server 2012 Read-Only Replica physical requirements

  - by Ddono25

  We are going to be setting up two replicas of our DataMart and related databases, and our plan includes using Hyper-V VM's to handle the load. When creating the VM's, we cannot find specific requirements or recommendations for RAM/CPU power for read-only replicas. Our current Primary DataMart setup has 64GB RAM and Two Quad-Core procs, which so far has been adequate for our usage. What should be the server setup for replicas and SQL Server to adequately support the read-only usage?

  Read the article

• SQL Server 2008 - Performance impact of transactional replication?

  - by cxfx

  I'm planning to set up transactional replication for a 100Gb SQL Server 2008 database. I have the distributor and publisher on the same server, and am using push subscription. Should there be a performance impact on my publisher server when it creates the initial snapshot, and synchronises it with a subscriber? From what I've tried so far on a staging server, it seems to slow right down. Is there a better way to create the initial snapshot without impacting my production publisher server?

  Read the article

• Cannot drop a table in SQL 2005

  - by David George

  I have a SQL Server 2005 SP3 box that one of my developers created a temp table on that we cannot seem to remove because it somehow got brackets in the name of the table? SELECT Name, object_id FROM sys.objects WHERE Name LIKE '%#example%' Results: Name object_id [#example] 123828384 Anyone know how we can get rid of this? Thanks!

  Read the article

• Setting up a SQL server outside the domain

  - by user41013

  Hi, im very new to this. I've set up an account "SQLBOX" thats on the a network, but not connected to the domain. I have installed an instance of SQL Server 2008 and am trying to connect to it from another machine on the network but am getting "Cannot connect to "SQLBOX"". From the "SQLBOX" i can connect to sqlservers on the domain, but not vice-versa. Any help would be grately appreciated. Sorry if the description isn't great. Thanks

  Read the article

• SQL Server: error when connecting

  - by atricapilla

  (migrated from stackoverflow) The application I'm using tries to connect SQL Server named instance running on a dedicated database server. Here's the error I'm getting: The TCP/IP connection to the host <instance_name>, port 1433 has failed. Error: Connection refused: connect. Is the firewall blocking my access or what? Should I dedicate a different port for this application?

  Read the article

• SQL Server: how to check securables

  - by jrara

  I would like to make a t-sql query to check which logins have 'view server state' permission in server type securables. How to achieve this? This query from mssqltips don't show this: http://www.mssqltips.com/tip.asp?tip=1718 SELECT prin.[name] [User], sec.state_desc + ' ' + sec.permission_name [Permission] FROM [sys].[database_permissions] sec JOIN [sys].[database_principals] prin ON sec.[grantee_principal_id] = prin.[principal_id] WHERE sec.class = 0 ORDER BY [User], [Permission];

  Read the article

• T-SQL for autogrowth of multiple data files

  - by ddono25

  I can't seem to figure out the problems with my script to alter SQL Server 2008 database and file growth. There are two data files and a log file, all which need to have Autogrowth ON. Does this look completely wrong? Thanks! USE MASTER GO ALTER DATABASE BigDB MODIFY FILE ( NAME = BIGDBPPE, FILENAME = "H:\MSSQL\Data\BigDB.mdf", MAXSIZE = UNLIMITED, FILEGROWTH = 2000MB) USE MASTER GO ALTER DATABASE BigDB MODIFY FILE ( NAME = BIGDBPPE1, FILENAME = "K:\MSSQL\Data\BigDB_data1.ndf", MAXSIZE = UNLIMITED, FILEGROWTH = 2000MB) USE MASTER GO ALTER DATABASE BigDB MODIFY FILE ( NAME = BIGDBPPE_log, FILENAME = "O:\MSSQL\Data\BigDB_log.ldf", MAXSIZE = UNLIMITED, FILEGROWTH = 200MB) GO

  Read the article

• Change port number via command line in SQL Server 2005

  - by ristonj

  I know how to change the port number via SQL Server Configuration Manager, but is there any way to do so via the command-line or sqlcmd? Thanks.

  Read the article

• PHP mySQL - replace some string inside string

  - by apis17

  i want to replace ALL comma , into ,<space> in all address table in my mysql table. For example, +----------------+----------------+ | Name | Address | +----------------+----------------+ | Someone name | A1,Street Name | +----------------+----------------+ Into +----------------+----------------+ | Name | Address | +----------------+----------------+ | Someone name | A1, Street Name| +----------------+----------------+ Thanks in advance.

  Read the article

• Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

  - by Sebastian Seifert

  I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How can I get these backup processes to stop so they release resources? Simply killing the processes doesn't work. The process will stay in KILL/ROLL for a long time. This didn't change for several hours.

  Read the article

• Search a string to find which records in table are inside said string

  - by Improfane

  Hello, Say I have a string. Then I have a number of unique tokens or keywords, potentially a large number in a database. I want to search and find out which of these database strings are inside the string I provide (and get the IDs of them). Is there a way of using a query to search the provided string or must it be taken to application space? Am I right in thinking that this is not a 'full text search'? Would the best method be to insert it into the database to make it a full text search?

  Read the article

• C string vs. C++ String

  - by JACK IN THE CRACK

  Whats better How to measure performance? ???????????????????????

  Read the article

• Interning strings in Java

  - by Tiny

  The following segment of code interns a string. String str1="my"; String str2="string"; String concat1=str1+str2; concat1.intern(); System.out.println(concat1=="mystring"); The expression concat1=="mystring" returns true because concat1 has been interned. If the given string mystring is changed to string as shown in the following snippet. String str11="str"; String str12="ing"; String concat11=str11+str12; concat11.intern(); System.out.println(concat11=="string"); The comparison expression concat11=="string" returns false. The string held by concat11 doesn't seem to be interned. What am I overlooking here? I have tested on Java 7, update 11.

  Read the article

• Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

  - by Sebastian Seifert

  I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How can I get these backup processes to stop so they release resources? Simply killing the processes doesn't work. The process will stay in KILL/ROLL for a long time. This didn't change for several hours.

  Read the article

• SQL Script fails with error: The login already has an account under a different user name

  - by Rock Hymas

  I have a script that creates a user associated with a login for SQL Server 2005. It does this immediately after creating the database and the login. One user of the script reported the following error: The login already has an account under a different user name Any idea how this might happen, and how I could modify the script to handle it?

  Read the article

• Add string to another string

  - by daemonfire300

  Hi there, I currently encountered a problem: I want to handle adding strings to other strings very efficiently, so I looked up many methods and techniques, and I figured the "fastest" method. But I quite can not understand how it actually works: def method6(): return ''.join([`num` for num in xrange(loop_count)]) From source (Method 6) Especially the ([numfor num in xrange(loop_count)]) confused me totally.

  Read the article

< Previous Page | 72 73 74 75 76 77 78 79 80 81 82 83  | Next Page >