Search Results

Search found 36788 results on 1472 pages for 'sql 2008'.

Page 693/1472 | < Previous Page | 689 690 691 692 693 694 695 696 697 698 699 700  | Next Page >

• Can I configure an SQL Server 2008 DB so that it will save all empty strings as NULLs?

  - by Ivan

  In my current project it would be convenient to exclude empty strings from the domain, so that is an empty string is met wherever, it is treated as NULL, for example if I UPDATE [table] SET [Something]='', SQL Server should treat it as SET [Something]=NULL, so that in next SELECT a NULL is returned as [Something] value. Should I use triggers or there is a better way?

  Read the article

• How To Work With SQL Database Added As Item In Visual Studio 2008?

  - by mdvaldosta

  If I'm letting Visual Studio take care of adding an SQL Server database to an existing project, it adds the connection string to app.config. How can I use use THAT connection string to make my own connections and datasets?

  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 would help. I get this when I drill into the CPU graph: Error: Difference of two datetime columns caused overflow at runtime.

  Read the article

• Should I move to an Azure database?

  - by Mike Flynn

  I am currently using a database from an installed instance on my web server in a VM on Azure. I was thinking about moving it to an actual Azure Database so I could load balance the web server. Does the Azure database work the same way as a straight install? Will it cost more or the same since I am just moving to a new server? Basically looking for advantages and disadvantages. I am familiar with SQL Server Management Studio.

  Read the article

• SSL security error

  - by shah

  What would the reason of getting the following error? Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

  Read the article

• MySQL - connection and security

  - by Phil Jackson

  Hi, I was wondering if someone could tell me if there is any potential security breeches that could occur by connecting to a sql database that does not reside at 'localhost' i.e. via ip address?

  Read the article

• Communication between 2 server

  - by Julien Garcia

  Hi, I have two server. One with sql server and another with dbf. I would like to access form MSSQL server to dbf server. But i haven't access to this server. How can i managed that? Thanks Julien

  Read the article

• Is there a way to restrict direct write access to the DB in Microsoft Access 2007?

  - by JW

  I'd like to set up an Access (2007) project that contains queries on a DB (actually in MS SQL Server 2005), but I do not want to allow any direct writing to the DB. (Basically, just read-only.) Is this possible? Thanks in advance!

  Read the article

• Install Sybase SQL Anywhere 11 as windows service

  - by student

  we are using Sybase SQL Anywhere 11. I am using command line to install/init database, dbinit -dba %username%,%pwd% -p 4k %dbLocation%, and start database server, dbsrv11 %dbLocation%, in a batch file. What I really want is install my database as Windows service and can be start/running automatically when machine get reboot. But I want to keep using batch for easy intall/uninstall/change it. Any Sybase expert here?

  Read the article

• One Database vs. Multiple Databases

  - by Ricardo

  I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project has the same data model, but is independent of all others. My inclination is to use one database to store all projects. What is your recommendation?

  Read the article

• What are the limitations of Upgrade Advisor when upgrading from sql2000 to 2005

  - by kareemsaad

  How well does upgrade advisor work for doing SQL Server 2000-2005 upgrades - what are the significant gaps that I might have to address through other means?

  Read the article

• Do data sources travel with a particular mail merge document?

  - by Andrew

  Do data sources that you set up (particularly to SQL Server) travel with a mail merge document? In other words, if I set up data sources in a mail merge document on my machine and then save and send that document to a co-worker and she opens it on her machine, will the data sources still be there when she opens it? Or, will she have to set them up again herself?

  Read the article

• Populating Specific Cells Using VBA

  - by Daniel

  I am using VBA to pull from a SQL table and it automatically populates cell E14. Not sure why it's that cell, but is there a way to specify which cell it pulls the data into? Here's what I have right now: strSQL = "SELECT distinct Source FROM dbo.Simulations WHERE SimulationID = 5

  Read the article

• Is it OK to run perfmon on production servers? And why?

  - by Bill Paetzke

  Or should perfmon be limited to a Dev/QA server with load tests that simulate production activity? I'd like to run perfmon for a two days (like Sql Server master Brent Ozar suggests) to get an overall feel of my web app's database performance.

  Read the article

• Do files uploaded count against your SharePoint site collection quota if using remote blob storage?

  - by Jim

  There is a debate going on in my group as we plan to use SharePoint 2010. We want to use Remote Blob Storage (RBS) instead of storing files in the SQL tables themselves. If we use RBS, do the files people upload still count against their site collection quota? To me, it seems obvious that they would. To others in my group, it seems obvious that it wouldn't.

  Read the article

• Capabilities and pricing of Amazon's cloud computing platform?

  - by inspirednow

  I'm finding it very hard to estimate how much my web application might cost running in Amazon's cloud? My app is similar to stackoverflow.com - asp.net, ajaz, sql database. Can anyone estimate how much it might cost to run stackoverflow in Amazon's cloud?

  Read the article

• how to write batchfile/storeproc for cheking the mail in the inbox using jobmanager [closed]

  - by ganesh

  Possible Duplicate: How can I handle emailed job control files for SQL Server? how to write batchfile/storeproc for cheking the mail in the inbox using jobmanager

  Read the article

• Which SQL database should I run?

  - by Chris Salij

  I'm creating my first website from hand-coded scratch (just used WordPress and Drupal before) and I'm at the point where I'm setting up my database for the site. However my host has given me 4 options to choose from in the database department. MS SQL Server 2005 MySQL PostgreSQL MySQL 5 Which should I go for? From what I understand PostgreSQL is meant for smaller databases with high access times. Though to be honost I'm not quite sure.

  Read the article

• Distributed transaction aborted by MSDTC

  - by aarsh thakur

  How to resolve the error 8522 in SQL Server 2005? I'm getting this error while I'm loading data from the remote server.

  Read the article

• Sharepoint and SSRS Native Integration - Not seeing web parts after cabinet file install

  - by Greg_the_Ant

  I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts) However after adding the cabinet file e.g., STSADM.EXE -o addwppack -filename "C:\ Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall I still don't see report explorer in the web parts list. I'm very stuck and confused :-(

  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

• Disable SQL Server at windows startup (VS 2010)

  - by ile

  After I installed Windows 7, booting lasted for about 40 seconds. Then I installed VS2010 and booting is 20 seconds longer. In task manager I see SQL Server process running. Is there a way to disable these programs at startup and fasten booting?

  Read the article

• What perfmon counters should I track for improvements to the query plan cache?

  - by Bill Paetzke

  I am parameterizing my web app's ad hoc sql. As a result, I expect the query plan cache to reduce in size and have a higher hit ratio. What should I track in perfmon regarding this? How could I report on this change? (I'd also accept an answer that queries the DMV tables or whatever else to report on the change).

  Read the article

• How see the converted sql from ActiveRecord method in view, etc

  - by Jak

  Hi All, I will be happy if someone clear doubt, i can see objects in view by using <%= debug @object % and lot of methods is there apart from view like .to_yml, etc Is there any method available for seeing the converted sql from ActiveRecord method in view, etc. Although I can find it in console but it will confuse when we run multiple queries.. example: User.find :all it will produce "SELECT * FROM users;" in output console But i want it in view are any other specific point like yml , etc ? Thanks, Jak

  Read the article

• How do you find all dependencies of a database table?

  - by Carlos

  In MS SQL 2005, is it possible to find out which tables/columns are being used either as keys in another table, or as part of a stored procedure? The reason is I'm trying to clean up some old stored procs and tables, some of which can be removed, some of which can have columns pruned. But obviously I don't want to remove stuff which is being used.

  Read the article

< Previous Page | 689 690 691 692 693 694 695 696 697 698 699 700  | Next Page >