Search Results

Search found 36186 results on 1448 pages for 'sql 11'.

Page 341/1448 | < Previous Page | 337 338 339 340 341 342 343 344 345 346 347 348  | Next Page >

• Why isnt sql management studio integrated in visual studio?

  - by Rob Packwood

  I have both SQL Server 2005 and Visual Studio 2008 installed and think it would be really nice to have SQL Management Studio integrated directly within Visual Studio. Is there a way to make that happen? What about in VS 2010 with SQL Server 2008? I find the Visual Studio Server Explorer window to be much slower too than the Object Browser in SQL…

  Read the article

• SQL Profiler and Tuning Advisor for Reporting Services - what events should be selected?

  - by chris

  I've used the SQL Profiler to generate a trace file, and tuning advisor to take that trace file and provide some recommendations on db updates. However, the SQL Profiler doesn't seem to track the queries when running against a Reporting Server, the profiler doesn't seem to be capturing any of the queries. I'm logging the defaults…

  Read the article

• How can I schedule a daily backup with SQL Server Express?

  - by edosoft

  I'm running a small web application with SQL server express (2005) as backend. I can create a backup with a SQL script, however, I'd like to schedule this on a daily basis. As extra option (should-have) I'd like to keep only the last X backups (for space-saving reasons obviously) Any pointers? [edit] SQL server agent is…

  Read the article

• Function inserted not all records

  - by user1799459

  I wrote the following code by data transfer from Access to Firebird def FirebirdDatetime(dt): return '\'%s.%s.%s\'' % (str(dt.day).rjust(2,'0'), str(dt.month).rjust(2,'0'), str(dt.year).rjust(4,'0')) def SelectFromAccessTable(tablename): …

  Read the article

• MS Access 2003 - Unbound Form uses INSERT statement to save to table; what about subforms?

  - by Justin

  So I have an unbound form that I use to save data to a table on button click. Is there a way I can have subforms for entry that will allow me to save data to the table within that same button click? Basically I want to add more entry options for the user, and while I know other ways to do it, I am particularly…

  Read the article

• Cardinality Estimation Bug with Lookups in SQL Server 2008 onward

  - by Paul White

  Cost-based optimization stands or falls on the quality of cardinality estimates (expected row counts).  If the optimizer has incorrect information to start with, it is quite unlikely to produce good quality execution plans except by chance.  There are many ways we can provide good starting information…

  Read the article

• Profile creation process stuck halfway Websphere

  - by ngubk

  I'm creating a cell profile on Linux Mint 12 , WAS 8.0 Network Deployment Trial. But using manageProfiles.sh or Profile Management Tool, I can not create any profile (cell, application ...). When I check the log file, the profile creation process is always stop halfway (does not show any error, just stuck…

  Read the article

• Is post-sudden-power-loss filesystem corruption on an SSD drive's ext3 partition "expected behavior"?

  - by Jeremy Friesner

  My company makes an embedded Debian Linux device that boots from an ext3 partition on an internal SSD drive. Because the device is an embedded "black box", it is usually shut down the rude way, by simply cutting power to the device via an external switch. This is normally okay, as ext3's journalling…

  Read the article

• How can I find the space used by a SQL Transaction Log?

  - by Sean Earp

  The SQL Server sp_spaceused stored procedure is useful for finding out a database size, unallocated space, etc. However (as far as I can tell), it does not report that information for the transaction log (and looking at database properties within SQL Server Management Studio also does not provide…

  Read the article

• How can I keep track of SQL Server updates?

  - by Adrian Grigore

  Hi, If I am not mistaken, SQL server cannot be automatically updated via the regular windows backup routine. Instead, there are cummulative updates that need to be installed by hand. I assume this is done for security and stability reasons. Is this correct? If so, how can I keep track of new…

  Read the article

• How mod_cache working with "must-revalidate" and "max-age"?

  - by Dmitriy Sosunov

  Quick question before I will explain my flow: ?an mod_cache perform revalidate with if-none-match only if max-age is expired in case if it configured in reverse proxy mode? My goal is to reduce a number of revalidation requests to our the origin server. For instance: The first request goes…

  Read the article

• How can I keep track of SQL Server cummulative updates?

  - by Adrian Grigore

  Hi, If I am not mistaken, SQL server cannot be automatically updated via the regular windows backup routine. Instead, there are cummulative updates that need to be installed by hand. I assume this is done for security and stability reasons. Is this correct? If so, how can I keep track of…

  Read the article

• Which tools are most commonly used to auto-encrypt backups for SQL Server 2005?

  - by blueberryfields

  I am looking to automate the encryption of my backups, and SQL Server 2005 does not appear to include built in functionality to do the work. Similar to the question here - http://serverfault.com/questions/72689/is-it-possible-to-configure-sql-server-2005-to-auto-compress-backups - I am…

  Read the article

• Used SQL Svr 2008 Config Manager to Set Service Account to Local System: What Did It Change?

  - by Frank Ramage

  Direct shot to foot moment... While setting-up individual non-admin accts for MSSQLSERVER services, I temporarily set Server service login to Local System account. I remembered later that: SQL Server Configuration Manager performs additional configuration such as setting permissions…

  Read the article

• How do I configure SQL Server to allow other users to access a database?

  - by Zian Choy

  Environment: Windows 7 Ultimate SQL Server 2005 Express 2 users on the computer I tried making the 2nd user a user in SQL Server (THINKPAD\2ndUser) and adding him to the database ("2ndUser"). Then, I logged in as 2ndUser and started Visual Studio 2008. When I tried to connect to…

  Read the article

• Potential issues with SharePoint 2007 and SQL Server default collation?

  - by MDRoz

  SharePoint installation guidance specifies that SQL Server collation should be set to Latin1_General_CI_AS_KS_WS (case-insensitive, accent-sensitive, Kana-sensitive, and width-sensitive). However, our internal hosting group uses the default SQL Server 2005 collation…

  Read the article

• Upgrade from SQL Server Express to Standard version, when using TFS2010?

  - by noocyte

  We're currently using SQL Server Express 2008 as backend for our TFS2010 install (Basic). Would it be possible to move to the standard (or better) version of SQL Server without any big hassels?

  Read the article

• Adding the domain account to a security group on the SQL Server computer that has sufficient privileges to log on as a service

  - by Alberto

  After reading this article, http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Backup/KB200710000173 I have some problems configuring point 2) and 3): 2) Create a SQL Server login that has the ability to backup (and restore) databases (y) by adding it…

  Read the article

• How do you enable Remote Connection with SQL Server 2008 w/o Installing Management Studio?

  - by danmine

  I'm having a rather tough time finding information on this since almost everything I read requires Management Studio installed in the server which I prefer not to do. Also, to connect to it using SQL Server Management Studio installed on the client, are these…

  Read the article

• SQL 2008: How can i create policies in policy based management from tsql script?

  - by Manjot

  Hi, I have some T-sQL scripts which i want use to create policies in SQL 2008. But every documentation i found explains creating policies from in build facets. when I try to create a policy using these scripts, I get error "property expressionNode is not…

  Read the article

• Where can I go to learn how to read a sql server execution plan?

  - by Chris Lively

  I'm looking for resources that can teach me how to properly read a sql server execution plan. I'm a long time developer, with tons of sql server experience, but I've never really learned how to really understand what an execution plan is saying to me. I…

  Read the article

• how to install MS SQL express database on Windows XP Home Sp3?

  - by Ankit

  I am trying to install MS SQL express on a windows XP home edition sp3 machine. But it does not satisfy the requirements. Is there a way to remove sp3 from my machine? Microsoft suggests that sql express will work windows XP home edition sp2. Please…

  Read the article

• When to use an MS SQL instance vs. different database on same instance

  - by BoxerBucks

  We have some MS SQL servers that are setup with different instances on the same server to separate applciation DB's as well as some servers that are setup with all DB's on the same instance, just separated with security settings. When is it…

  Read the article

• SQL Server on VMWare - is transaction log corruption possible?

  - by demp

  Scenario: SQL Server 2005 or 2008, Windows 2008 OS. Running in a VM hosted on VMWare ESX server. Is there any known issue with VMWare when it caches pass-through write request and it never reaches the disk, while SQL Server "thinks" that…

  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

< Previous Page | 337 338 339 340 341 342 343 344 345 346 347 348  | Next Page >