Search Results

Search found 31931 results on 1278 pages for 'sql statement'.

Page 381/1278 | < Previous Page | 377 378 379 380 381 382 383 384 385 386 387 388  | Next Page >

• Deadlock Problem because of an Update Lock.

  - by Randy Minder

  We have a deadlock issue we're trying to track down. I have an deadlock graph (xdl) generated from Profiler. It shows the losing SQL statement as a simple Select statement, not an Update, Delete or Insert statement. The graph shows the losing Select statement as requesting a Shared lock on a resource **but also owning an Update lock on a resource**. This is what is baffling me. Why would a Select statement that is not part of an Insert, Update or Delete ever hold an Update lock on a resource? I should add that the Update lock it owns is on the table being selected against by the losing Select statement.

  Read the article

• Synchronize Azure SQL (cloud) with Azure SQL Emulator (local)?

  - by Sid

  We have an Azure service (web role) that heavily depends on the database. For offline development/testing, we'd like to have the app+db run offline within the emulators. Running the webrole itself within the emulator is straightforward but doing so for the Azure SQL storage isn't so. What is the simplest way to ensure that the cloud Azure SQL database and the emulator/local Azure SQL database are in sync? We can afford some level of staleness for simplicity of sync operation (meaning it's ok for the local copy to be a few hours stale versus mirroring every write as soon as it happens) Thanks

  Read the article

• Does SQL Server Maintainance Cleanup consider exact times when deleting old backups?

  - by Heinzi

  Let's say I have a daily maintainance task that: Backups all databases and then removes backups that are older than 3 days. Now let's say the first backup at day 1, starting at 10:00, results in the following files db1.bak 2012-01-01 10:04 db2.bak 2012-01-01 10:06 Now let's say at day 4 the first step of the maintainance task (backup the DBs) happens to finish at 10:05. Will SQL Server delete db1.bak and keep db2.bak (would be logical, but might be surprising for the user) or keep both or remove both?

  Read the article

• What is the best powershell script to restore an SQL Database?

  - by EtienneT

  To restore an SQL Server 2008 database, I would lile to be able to just do something like this in powershell: ./restore.ps1 DatabaseName.bak Then the powershell script would by convention restore it to a database with name "DatabaseName". It would disconnect any user connected to this database so that it can restore the DB. It would store the mdf and ldf in the default location. This would mainly be while developing on my personal machine. Just a quick way to restore a DB. Anyone has such a script? Thanks

  Read the article

• How do I give a user permission to install Report Builder from Report Manager? (SQL Server 2008)

  - by ScottStonehouse

  By default, users do not see the "Report Builder" button on the Report Manager toolbar in SQL Server 2008 (R1). How do I give the user permission to use the Report Builder?

  Read the article

• error when configuring sql reporting services 2005 on windows 7 ultimate : There was an error when s

  - by Omu

  I've installed sql server 2005 with reporting services on windows 7 ultimate and when I try to configure it when clicking on "Windows Service Identity" I get this error message: There was an error while switching panels. The most likely cause is an error retrieving WMI properties. The exception details are: InvalidArgument=Value of '1' is not valid for 'SelectedIndex'. Parameter name: SelectedIndex here is a screenshot:

  Read the article

• Free tool to write Performance Counters to MS SQL Database?

  - by Michael Stum

  Is there some (free) tool that reads Performance Counters (Windows 2008 Server, but 2003 support is a bonus) and adds them to a MS SQL Server 2008 database? Doesn't need to be too fancy as in the worst case I can add "log rotation" through triggers.

  Read the article

• How to remove trailing spaces from SQL Server logical filename?

  - by Luke Girvin

  I'm dealing with a server running SQL Server 2000 SP1, and the logical filenames for one of the databases appear to contain trailing spaces. That is, this query: select replace(name, ' ', 'X') from sysfiles Returns the expected names plus a long string of Xs. How can I deal with this? I've tried running ALTER DATABASE... MODIFY FILE using the name (with and without spaces) and get an error message telling me the file does not exist.

  Read the article

• What are the dangers of using parallelism on sql server?

  - by Lieven Cardoen

  At a customer of ours, the sql server is configured to 1 for degree of parallelism. The server has 8 cpu's, so what would be reason to limit this degree to 1?

  Read the article

• How to format the name of the SQL Server 2008 backup file ?

  - by PeterMmm

  I define a backup task form the SQL Server 2008 Management Studio. The task creates backup files with name db_backup_YYYY_MM_DD_HHMMSS_ID.bak Is there a way to change the format. I'm interestet of the weekday db_backup_weekday.bak

  Read the article

• How can I handle emailed job control files for SQL Server? [closed]

  - by ganesh

  How can I detect control files from any mailbox, scan that file, decrypt it and queue it as a job using job manager in SQL Server?

  Read the article

• How can I set up port forwarding for SQL Server 2005?

  - by Manish

  Hello Subject :how to use port forwarding Internet------> Router in my network ------->LocalMachine (Windows 2003) -->Sqlserver2005 How can I access SQL Server through the internet via a router in the local network? My router IP Address is =192.168.1.86; My local machine which is connected to the router Ip Address is= 192.168.1.81 At port No=1433 tell me how to use port forwarding Thanks for help in advance

  Read the article

• Overnight SQL Server Full Backup taking 4x longer, everything else slower, RAID problem?

  - by Tom

  Sql Server on Windows Server 2008: Overnight, fullbackups taking 7-10 hours instead of 1-3 transaction logs taking 4-5 minutes instead of 1 minute Query optimization taking 3x longer I'm feeling like a disk in my Raid Array (raid5) is faulty or the raid controller or network card, Rackspace is telling me everything is fine. Any ideas on what/how I need to check?

  Read the article

• How can I install SQL Server 2005 on Windows 2008 R2?

  - by Jim Geurts

  Is it possible to install SQL Server Express 2005 SP3 on Windows 2008 Server R2? If so, is there anything special that needs to be done to get it to install properly? I ran into some issues with the installer and wasn't sure if it could be installed with 2008 R2.

  Read the article

• SQL Server 2005 on laptop. Not sure if I can delete

  - by WebDevHobo

  I have SQL Server 2005 on this laptop. I probably got installed along with Visual Studio. The thing is, I don't use it and it's constantly running. Process Explorer reports that it has a virtual Size of 1.5 GB. I want to uninstall this, but I'm not sure if there are any other processes dependent on this.

  Read the article

• SPROC runs in Query Analyzer 2008 Enterprise but will not run inside a Job on SQL Agent

  - by jim-johnston

  I have a stored procedure that runs in Query Analyzer 2008 Enterprise but will not run inside a Job on SQL Agent. It just spins. I have checked permissions, ANSI NULL ON , etc. to no avail. Funny thing is I can wrap a SSIS package around it and then run it from a Agent Job and it works. Any ideas? Thanks in advance V/R Jim

  Read the article

• Configuring SQL for optimal performance... SSD or HDD?

  - by spoon16

  Does anyone know of any comparisons that show how SSDs compare to HDDs for performance in a SQL environment? I'm trying to understand what type of performance benefit might be gained by moving to SSD.

  Read the article

• How many times can I reinstall SQL Server 2008 using the same product key?

  - by twpc

  I have attempted to install SQL Server 2008 twice so far, but have gotten errors. Would like to try again. Is there a limited number of times that the same product key can be used before I have problems?

  Read the article

• Setting up a linked server to another server which isn’t in a domain without using SQL authenticatio

  - by Telos

  Server A (SQL2005) is in our primary domain, but server B (SQL2000) is just in a windows workgroup. We are not allowed to join it to the domain, or bad things happen... We also can't enable SQL authentication on server B. We've got domain accounts for A, and matching local accounts on server B. I can connect to B from my local PC or A using SSMS and a domain login, but I can't get the linked server to connect. Any ideas how to do this?

  Read the article

• How do I change the Web Service Account for SQL Server Reporting Services?

  - by anD666

  Hello, I am trying to configure a Report Server on SQL Server 2005 and need to change the ASP.NET Web Service Account. Can anyone point me in the right direction of how to do this. Thanks Andy

  Read the article

• Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment?

  - by Michael Rosario

  Hello world. Can Oracle XE and Microsoft SQL Server 2005 run on the same server in a production environment? From an IT professional position, why would I not allow Oracle XE and MSSQL2005 to run on the same server?

  Read the article

• How can a cached query take 2500 ms on a Sql Server 2008?

  - by Lieven Cardoen

  How is it possible that a cached query could take that long. With cache cleared it takes 25000 ms (I know that's just way too long but that's not the issue here). Once it is cached, it takes 2500 ms. What could be the problem here? If it's cached, I assume Sql Server gets it out of the RAM. So, again, 2500ms???

  Read the article

• Is there a rule to define a primary key on a sql-Server table for access with MS-Access?

  - by Ice

  Defining some Tables in SQL-Server which will be accessed via ODBC from MS-Access. I'm not sure about it, put i read somewhere that a primary key must bee named with 'aaaaaPK_ColumnName'. The 5 'a' should manage that the PK is listed first in the dialog for all key's in MS-Access. What do you think about that?

  Read the article

• What is the best powershell script to restore an SQL Database?

  - by EtienneT

  To restore an SQL Server 2008 database, I would lile to be able to just do something like this in powershell: ./restore.ps1 DatabaseName.bak Then the powershell script would by convention restore it to a database with name "DatabaseName". It would disconnect any user connected to this database so that it can restore the DB. It would store the mdf and ldf in the default location. This would mainly be while developing on my personal machine. Just a quick way to restore a DB. Anyone has such a script? Thanks

  Read the article

• How to Export SQL Server IMAGE data to Oracle's BLOB?

  - by alextansc

  I'm trying to export a table with IMAGE data type fields in SQL Server 2005 to a table with BLOB data type fields in Oracle 11g. What is the recommended way to perform this operation, assuming we have more than a thousand records to export at once?

  Read the article

< Previous Page | 377 378 379 380 381 382 383 384 385 386 387 388  | Next Page >