Search Results

Search found 27905 results on 1117 pages for 'sql authority'.

Page 468/1117 | < Previous Page | 464 465 466 467 468 469 470 471 472 473 474 475  | Next Page >

• 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

• 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

• 60Gb of Memory, 32-bit OS and PAE vs 64-bit OS

  - by dynback.com

  I have 60 Gb of RAM on server. Windows 2008, 32bit with PAE. One Sql Server 2008 Express Instance can use 1 Gb of RAM. So if I install 60 instances, each can use 1 Gb of RAM, right? And the second question, what will be if I install 64bit system and use many Express instances?

  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

• 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

• BizTalk Server 2009 highly available configuration

  - by Matthew

  Hi. I am setting up a BizTalk 2009 Server production environment and I wonder if this tutorial: http://msdn.microsoft.com/en-us/library/cc558972(BTS.10).aspx is still fairly accurate for an installation on all the latest platform software (Hyper-V, Windows Server 2008, BizTalk Server 2009, SQL Server 2008)? Is there anything like this but more up to date? Any other advice about this process and links to articles, blogs & tutorials would be appreciated.

  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

• 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

• 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

• 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

• Connection error when trying to browse SSAS cube in BIDS

  - by lance

  SQL Server 2008 db instance is installed on a win 2003 server, networked (but no domain) VM. I can browse a cube from BIDS on the same VM, but when I try to browse the same cube on a windows 7 (home premium) networked machine, I get a connection error. The error suggests checking the datasource settings which I have, and when I click "test connection" on the datasource it is successful. Looking for probably causes and solutions?

  Read the article

• Partition 500gb of database stored in SQL Server

  - by Devendra

  Hello I have 500GB of database stored in SQL Server. Because it has too big a database, it takes time to update and insert data. Now the case is that I want to partition the data. So which partitioning techniques should I use? Or is there any other technique which will improve my performance?

  Read the article

• Any specific issues found running HP Quality Center 10.0 on SQL Server 2008

  - by BrianP

  Has anyone successfully gotten HP Quality Center 10.0 installed and running using the as-yet unsupported Microsoft SQL server 2008? Have you hit a specific issue? e.g. any issues with full text search etc.

  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

• why restoring database never finishes?

  - by LingAi

  Hi all, I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring. Does anyone know what's the problem? Thanks, Ling

  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

• Setting Low Disk Space Alerts on Windows Server 2008

  - by rmwetmore

  I was wondering if there is an easy way to trigger an e-mail alert on Windows Server 2008 when any logical disk partitions become low on space. I have 2 SQL servers that have come close to running out of disk space because of the DB log files. Thanks, Ryan

  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

• Administrator can run a application but produces error while a administrator previllaged user can run without error

  - by tough

  I have an application which can run as admin prevailed user without error but while administrator runs it it produces error. The input string was not in correct format-application error. I tried to figure it out but not possible, since most of the people are looking for admin privilege to run it, me looking why can't a admin run the program without errors? The program is related to mssql-2008 r2. The SQL log-in settings are same for both the users.

  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

• How to show the "Home" folder for SSRS 2008 in SQL Management Studio

  - by kd7iwp

  I just installed SSRS 2008 on a development server and when I connect to it with SQL Management Studio I do not have all of the items in Object Explorer that I had with our SSRS 2005 installation. For example, we are missing the "Home" folder which lists all the reports. When we browse to our /ReportServer URL we can view and run our reports, so I know they are on the server. Does anyone know if this is a permissions issue or something else?

  Read the article

• How to show the "Home" folder for SSRS 2008 in SQL Management Studio

  - by kd7iwp

  I just installed SSRS 2008 on a development server and when I connect to it with SQL Management Studio I do not have all of the items in Object Explorer that I had with our SSRS 2005 installation. For example, we are missing the "Home" folder which lists all the reports. When we browse to our /ReportServer URL we can view and run our reports, so I know they are on the server. Does anyone know if this is a permissions issue or something else?

  Read the article

• Basic requirements in a laptop for running VS2010 and SQL Server 2008 smoothly

  - by Yajuvendra

  Planning to buy a laptop(reasonable budget). I want to know the basic requirement to run VS2010 and SQL Server 2008 smoothly with Adobe Photoshop CS4 and Dreamweaver CS4 in Windows 7 Home. Can Pentium Processor do the job? If not please Suggest me. Thank you.

  Read the article

• Add second ip address to an existing SQl 2008 failover clustering

  - by Cédric Boivin

  Hello, I got actually a failover cluster on Windows Server 2008, with sql server 2008. On each server i got two network card, with two different network one are on 10.10.10.x and other are on 192.168.99.x I want my sqlserver cluster listen on the two network. Is it possible and how i add new ip address. When i add a new ip address directly in the cluster, and i do a telnet on the 1433 port with the new cluster ip address it's not working. Thanks

  Read the article

< Previous Page | 464 465 466 467 468 469 470 471 472 473 474 475  | Next Page >