Search Results

Search found 33316 results on 1333 pages for 'sql team'.

Page 190/1333 | < Previous Page | 186 187 188 189 190 191 192 193 194 195 196 197  | Next Page >

• Do You Develop Your PL/SQL Directly in the Database?

  - by thatjeffsmith

  I know this sounds like a REALLY weird question for many of you. Let me make one thing clear right away though, I am NOT talking about creating and replacing PLSQL objects directly into a production environment. Do we really need to talk about developers in production again? No, what I am talking about is a developer doing their work from start to…

  Read the article

• Access to SQL Server when administrator account deleted

  - by Shiraz Bhaiji

  An interesting situation here. We have a database server, used for testing only, where someone went in and deleted the administrator login. Since this is a test server the was no other admin level login on the server. Is there a way to get access to the server again without reinstalling SQL Server? We do not need the data in the databases,…

  Read the article

• SQL locks between databases

  - by jesusbolivar

  Can a locked table on one database interfere with the operations of another database? The two databases aren't aware of each other. This is on SQL Server 2005.

  Read the article

• Minimum install of SQL Server 2008 required to able to run bcp

  - by Jon

  I need to run bcp.exe on a client machine which has no SQL Server 2008 installed. Does anyone know the minimum install options I need to select to get the bcp tool? I tried 'Client Tools Connectivity' but that didn't include it. Thanks, Jon

  Read the article

• trying to install SQL 2008 on Windows 2008 server R2

  - by Nezdet

  Hi I was trying to install MSSQL 2008 server on Windows 2008 server R2 Standard Machine, but I got this message: Program Compatibility Assistant, And that I should apply SQL server 2008 SP 1 I don't get it? Why doesn't it not work with this version I have? How should I solve this problem?

  Read the article

• I need Microsoft SQL Clustering/Replication/Scaling Best Practice Resources

  - by efk

  I'm trying to plan for our future scalability of our Microsoft SQL 2000/2005/2008 infrastructure. I'm having a hard time finding good information on how to best engineer such services, how to best keep these services available, and how to scale them as load increases. Can someone point me in the right direction? Books, online resources,…

  Read the article

• Shrink Sql Server database

  - by hani

  My SQL Server 2008 database file (.mdf) file is nearly 24 MB but the log file grown upto 15 GB. If I want to shrink database what are the important points to take into consideration? Will shrink causes any index fragmentation and does it affect my database performance?

  Read the article

• In retrospect, has it been a good idea to use three-valued logic for SQL NULL comparisons?

  - by Heinzi

  In SQL, NULL means "unknown value". Thus, every comparison with NULL yields NULL (unknown) rather than TRUE or FALSE. From a conceptional point of view, this three-valued logic makes sense. From a practical point of view, every learner of SQL has, one time or another, made the classic WHERE myField = NULL mistake or learned the hard…

  Read the article

• Trying to upgrade SQL Server 2008 to R2 but SQL is sleeping or dead?

  - by oJM86o

  I've used the option to upgrade SQL Server 2008 to R2 but I noticed it gets to about 20-30% and it just sits on this screen: I've left it alone for over 2 hours, the PC is definately not frozen cause I can click the help or move the window around but it says "Install_sql_common_core_loc_Cpu64_1033_action: Install Files. Copying…

  Read the article

• Locking User account created under Windows Authentication in SQL Server

  - by Santhosha Kaldambe

  Hi, As per my project requirement i need to lock a user in SQL Server(Which is created using Windows Authentication). Is there any way to do this? Thanks for the help Santhosh

  Read the article

• Grant access to the extended properties of a sql server database

  - by Pierre-Alain Vigeant

  In Sql Server 2008, Our database uses an extended properties. We noticed that a user that does not have the sysadmin role cannot read any extended properties. What access should be granted to allow a user that has the public role to read the extended properties?

  Read the article

• MYSQL Installation Problem...

  - by Gopal

  I was downloaded the MYSQL from this link http://dev.mysql.com/downloads/mysql/ But i cannot able to find the Installation file... How to create database & Table in mysql? It will work like SQL server or ? Need Help

  Read the article

• Securing data inside Azure SQL? Any good libraries or DIY?

  - by Sid

  Azure SQL doesn't support many of the encryption features found in SQL Server (Table and Column encryption). We need to store some sensitive information that needs to be encrypted and we've rolled our own using AesCryptoServiceProvider to encrypt/decrypt data to/from the database. This solves the immediate issue (no cleartext in…

  Read the article

• Using both IIS6 and IIS7 with the same SQL State Server

  - by Josef

  We are trying to use new IIS7 (32bit, Classic Mode) webs in addition to our IIS6 webs with one SQL State Server for ASP.NET Session Handling. Unfortunately the number of transactions per seconds in the State Servers spikes (10 times+) as soon as we add the new IIS7 web to the farm. Are there any known issues with the described…

  Read the article

• SQL Server 2005, Huge LDF file.

  - by Scott Jackson

  Hi, I have a database running on SQL Server 2005. The database is 20Gb and the LDF file is 35Gb ! I'm now running low on disk space and want to shrink the log file. How can I do this and how can I stop this happening again ? Many thanks Scott

  Read the article

• Problem installing SQL Server client tools

  - by Shiraz Bhaiji

  We are tring to install SQL Server 2005 Standard on Windows 2008 Standard both 64 bit. Have done this before with no problems. This time we get an error during the installation of client tools: There was an unexpected failure during the setup wizard Link Id 20476, message ID 50000 There are no errors in the event…

  Read the article

• Upgrade MS Sql Report Server 08 for Dundas charts

  - by hadi

  Hi, We have ms sql server 2008, however the new dundas charts are not available on the report server. How do I upgrade the report server so it gets the new dundas charts as well. Dundas charts are a part of Microsoft charts now in the new version of the report server. Your help would be greatly appreciated

  Read the article

• Windows SQL Server Cluster Failover Without Disruption

  - by Jim

  Is MS SQL server clustering capable of performing a seamless fail over between nodes? That is, where the clients wouldn't notice anything had changed except perhaps a short delay during the transition. Thanks, Jim

  Read the article

• SQL Server Management Studio Express - include date/time in Results or Messages

  - by Shevek

  In SQL Server Management Studio Express 2008 is it possible to output the date and time that a query completed in the Results or Messages windows? (without having to manually add a SELECT Getdate() to every query)

  Read the article

• MS SQL SERVER 2008 install

  - by Brandon Grossutti

  If i have a one processor license for ms sql 2008 can i just click to turn on the other processor in the event i buy another license?

  Read the article

• Developing Schema Compare for Oracle (Part 1)

  - by Simon Cooper

  SQL Compare is one of Red Gate's most successful SQL Server tools; it allows developers and DBAs to compare and synchronize the contents of their databases. Although similar tools exist for Oracle, they are quite noticeably lacking in the usability and stability that SQL Compare is known for in the SQL Server world. We could…

  Read the article

• SQL 2005: Maximum number of columns per table?

  - by Level1Coder

  In MS SQL 2005, how many columns can you create in a table before hitting the limit? I think it is 1024 columns per table but I'm not 100% sure. Just need a confirmation. Thanks!

  Read the article

• Which type of certificate for encrypting SQL Server?

  - by David Stratton

  Does it matter? We buy our certificates from Thawte, and I don't see a special type of certificate for SQL Server as opposed to a certificate you'd buy for a web server. Please be gentle with me if this is a dumb question. I'm a developer, not a server specialist.

  Read the article

• Buying Microsoft SQL Server 2008 Web Edition

  - by Marco

  I want to buy Microsoft SQL Server 2008 Web Edition in order to remotely install it on the server. The question is: Can I buy a licence in USA and pay in US dollars? OR do I have to buy it in my country (Portugal)? Since the servers are in Germany, should I buy the licence in Germany? (And if anyone know a good reseller I…

  Read the article

• Recommended Server RAM for SQL Full Text Search (FTS)

  - by David

  I gather SQL Server 2008 Express requires a minimum of 512MB RAM to be installed to run on Windows Server 2003, however will this be sufficient to also run Full Text Search on about 50,000 records? I don't want to pay too much and I have seen a 512MB RAM VPS option that interests me. Thanks

  Read the article

< Previous Page | 186 187 188 189 190 191 192 193 194 195 196 197  | Next Page >