Search Results

Search found 855 results on 35 pages for 'mssql'.

Page 7/35 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >

• Numeric Order By In Transact SQL (Ordering As String Instead Of Int)

  - by Pyronaut

  I have an issue where I am trying to order a result set by what I believe to be a numberic column in my database. However when I get the result set, It has sorted the column as if it was a string (So alphabetically), instead of sorting it as an int. As an example. I have these numbers, 1 , 2, 3, 4, 5, 10, 11 When I order by in Transact SQL, I…

  Read the article

• Problem with Executing Mysql stored procedure

  - by karthik

  The stored procedure builds without any problem. The purpose of this is to take backup of selected tables to a script file. when the SP returns a value {Insert statements}. I am using the below MySql stored procedure, created by SQLWAYS [Tool to convert MsSql to MySql]. The actual MsSql SP is from…

  Read the article

• Better Data access components for windows desktop application

  - by KoolKabin

  Which one can be the better one data access component for desktop application and why? 1.) For MS Access 2007: ADO, OLEDB, DAO 2.) For MSSQL 2005: ADO, OLEDB, DAO

  Read the article

• MS SQL - Problem running SQL Server Agent Job via service account credentials

  - by molecule

  There are 5 steps in this job. First job is an SSIS Package store, second to fifth are file system jobs. We configured all jobs to use Windows Authentication. Under Run As, we specified a user account which was created under SecurityCredentials and SQL Server AgentProxiesSSIS Package execution. The…

  Read the article

• How do you fix the Performance Dashboard datetime overfow error

  - by Mike L

  I'm a programmer/DBA by accident and we're running SQL Server 2005 with Performance Dashboard for basic monitoring. The server has been up for a few weeks and now we can't drill into certain reports. Is there any way to reset these reports without a complete reboot? edit: I bet the error message…

  Read the article

• SQL Server Management Studio not scripting all objects

  - by Ian Boyd

  i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the options being selected including all tables the folder where the script files will go the folder…

  Read the article

• Performance issues concurrently running MySQL and MS SQL Sever

  - by pacifika

  We're considering installing MySQL on the same database server that has been running MS SQL Server. From my research there are no technical issues running both concurrently, but I am worried that the performance will be affected. Is by default SQL Server set up to use all available memory for…

  Read the article

• SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

  - by user102718

  We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark the "copy-only" flag in Management Studio they will mess up the Tivoli's backups (we are…

  Read the article

• MS SQL server install failed: "unable to load activeds.dll"

  - by judahgabriel

  Hi guys, When I try to install Microsoft SQL 2008 R2, I get the following error durring install: Any ideas why SQL server is failing to install? Windows 7 Ultimate 64bit, Intel x64 CPU, 4GB ram.

  Read the article

• How could I import Postgres data dumps into MS SQL?

  - by dean nolan

  I have some data that is from a Postgres database dump (not csv or anything) and I am looking to get it into MS SQL. Is there an easy way to do this or a free tool that doesn't have limits on data import size etc? The Postgres is on a Debian VM and I could export it to csv in there but I…

  Read the article

• MS SQL 2000 and SSL Certificate

  - by smoak

  I'm trying to set up a MS SQL 2000 server to use an already existing SSL certificate installed on the server. I verified that the certificate shows up in the Personal/Certificate folder of the account that is running the MSSQLSERVER service using the Certificate MMC snap-in. I also…

  Read the article

• Change Windows Authentication user for Sql Server Management Studio

  - by Asmor

  We're using Sql Server 2005 with Windows Authentication setup. So normally, when you log in using e.g. Sql Server Management Studio, it forces you to log in at MACHINE_NAME\Username. Anyways, on this one particular computer, the person said they had to make a new account called…

  Read the article

• SQL restore from single file db to filegroup

  - by Mauro

  I have a 180GB MOSS 2007 database whose maintenance (i.e. backups and restores) are becoming a problem. Part of the issue can be resolved by splitting the three content sites down into their own site collections, however this will likely still leave me with a 100gb DB to deal…

  Read the article

• Option do not show schema names in SQL Server Management Studio

  - by Jörgen Sigvardsson

  I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you. This works in SSMS, but there's an annoying problem, especially so in the table node. SSMS…

  Read the article

• MS SQL server services not installed - help!

  - by judahgabriel

  Hi guys, I've installed SQL Server 2008 R2, but connecting to my local machine in SQL Management Studio fails: Putting "localhost" or "." as the server name results in the same error. I've narrowed down the problem: there are no SQL services installed: Bringing up the…

  Read the article

• How should I perform database maintenance on a 24x7 system

  - by solublefish

  I'm a software developer who inherited a part-time DBA role. I'm responsible for an application backed by a small, high-volume 24x7 database on SQL Server 2008. While there's other stuff in the DB, the critical piece is a 50GB, 7.5M row table that serves 100K requests/sec…

  Read the article

• Results copied from SSMS splitting across columns when pasted into Excel

  - by adolf garlic

  SSMS 2008 - Excel 2003 This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to columns' wizard with 'spaces' and 'brackets' as delimiters, meaning that the…

  Read the article

• Missing menu items for Azure SQL tables within SQL Server Management Studio?

  - by Sid

  I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table values etc ) is identical to the best of my understanding. However,…

  Read the article

• Realtime MS SQL Database transfer

  - by user34402

  Hello, I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime. Is there any way to do it?

  Read the article

• Is there any way to attach a database created in MS SQL Server 200808R2 to a SQL08 server?

  - by flashnik

  I created a database using a november CTP preview of MS SQL Server 2008R2. Is it possible to transfer this database to use with older version, SQL Server 2008?

  Read the article

• MS SQL server 2005 replication

  - by hubertus

  Hi. I have a problem with replication between 3 servers. I made something like this: server A replicate (transactional replication) to server B (to 'mydb' database), then server B replicate 'mydb' (using transactional replication) to server C. On the beginning it…

  Read the article

• MSSQL - Physical connection is not usable Error Code: 19

  - by Harry

  Having trouble working out this SqlException: A transport-level error has occurred when sending the request to the server. (provider: Session Provider, error: 19 - Physical connection is not usable) Any ideas what this is about? Couldn't get any…

  Read the article

• Bind DropDownList with Hierarchy from MSSQL Table with ASP.NET C#

  - by Gal V

  Hello all, I have the following sql table which contains menu (website menu) data. Table Name: MenuItems Columns: Id, MenuId, ParentMenuItemId, Text. My goal is to bind a DDL according to the following hierarchy (example): Id: 1, MenuId: 1,…

  Read the article

• sonarinstall Sonar to mssql

  - by senzacionale

  My server name in SQL management studio is: MITJAB-NOTEBOOK\SQL2008 i trx now install sonar in this server: sonar.jdbc.url: jdbc:microsoft:sqlserver://MITJAB-NOTEBOOK\SQL2008:1433;DatabaseName=Sonar;SelectMethod=cursor…

  Read the article

• Common way to compare timestamp in oracle, postgres and mssql

  - by Pratik

  Hi There! I am writing a sql query which involves finding if timestamp falls in particular range of days . I have written that in the postgres but it doesn't works in oracle and msssql. Is there are common way to…

  Read the article

< Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14  | Next Page >