Are there Free SQL Server Mgmt Studio Autocomplete Add-ins?
I know Red Gate has such a product, but I'd rather not have to pay for something which, in my opinion, should be built into SSMS. Thanks! ...
sql-server
How does ADO.Net know which version of the SQL Native Client to use if you have both SQL 2005 and 2008 in your environment?
How does ADO.Net know which version of the SQL Native Client to use if you have both SQL 2005 and 2008 in your environment? ...
Will T-Sql SET parameters be reset with pooled .NET connections?
The only SET parameter that I have found specific guidance for is SET TRANSACTION ISOLATION LEVEL: If you issue SET TRANSACTION ISOLATION LEVEL in a stored procedure or trigger, when the object returns control the isolation level is reset to the level in effect when the object was invoked. For example, if you set REPEATAB...
What is the equivalent of varchar(max) in Oracle?
What is the equivalent of varchar(max) in Oracle? CLOB? ...
How to display loading graphics in Firefox in Microsoft Reporting Services
I am using MS reporting services and some of the reports are taking longer than it should. By default the report viewer displays a loading graphics in IE. However, this graphics is not visible in Firefox. It works fine in IE. How can I display the loading graphics in Firefox? Any help would be appreciated. Thanks in advance. Regards N...
What is the best way to debug CLR stored procedures
I have a fairly complex CLR stored procedure. What is the best way to debug the procedure? I would like to step through it if possible. ...
Hiring a SqlServer OLTP Specialist, What experience or requirements should I look for?
I'm running into Db performance issues with an OTLP project I'm working on. Another developer and I have reached the end of our accumulated performance knowledge and seek out an individual to join the team to help us speed up our application. For some background we've done schema changes to denormalize pieces of the data, optimized eve...
Connection pooling session settings
First off happy new year guys. I have a small but significant query. I'll give a similiar use case but simplified, it does however cover my question. Let's User A connects to the SQL Server 2000 database and we get a connection from the pool. User A sets dateformat DMY. Finishes and the connections is released back to the pool. Use...
SQL code import into Access 2007
Hey everyone, I basically need to know how to import SQL code into Access. I've tried one way but that requires me to do one table and one value at a time which takes a lot of time. Can anyone help? ...
How do I reference SSIS on a build machine without installing SQL Server 2008 Client Tools?
I need to build SSIS packages on a build machine, and do not want the overhead of installing SQL Server Management Studio on this machine. A SQL Server 2008 SDK would be ideal, but I could not find where to download it. The dlls I require are (for example): Microsoft.SQLServer.ManagedDTS Microsoft.SqlServer.PipelineHost Microsoft.Sql...
DTS DB2 Connection Problem
Hi all, I want to copy an Oracle Database to a DB2 one using DTS in SQL Server 2000. When I set up both connections using their respective driver, I can read both databases, and link the copy operations between them. But when I want to run the DTS package, an error shows up saying "Driver not capable." Here's the log, thanks in advan...
Insert Picture into SQL Server 2005 Image Field using only SQL
Using Ms SQL Server 2005 and Management Studio how do I insert a picture into an Image type field of a table? Most importantly how do I verify if it is there? ...
How can I programatically translate a MSSQL server alias to an IP address using .NET?
The Windows default instalation comes with MSSQL client has a cliconfg application that is used to set aliases to Servers IP addresses and ports. Sometimes we use in our ConnectionStrings some of those aliases instead of IP address,port. How can I programatically translate that alias to an address using .NET? Update: .NET + Windows auto...
How do I make a boolean calculated field in TSQL and join on that calculated field?
First check out this code. I seems like it should work for me, but it doesn't! (surprise!) Anyway, this is what I tried first: SELECT Status as status, Address as ip, PCName as pc_name, (Numbers.Phone = 'CPU/' + PCName) as cpu_contact, (Numbers.Phone = 'PC/' + PCName) as pc_contact, (Numbers.Phone = 'LOGIN/' + PCName) as login_contac...
XML and Sql Server 2005
Hi, i have a problem that I want to resolve in a best possible way. The thing is that I made a schema that looks like this: print(" <xs:complexType name="rentACarT"> <xs:sequence> <xs:element name="poslovnice" type="poslovniceT" /> <xs:element name="korisnici" type="korisniciT" /> </xs:sequence> </xs:complexType> <xs:...
What does the sys.dm_exec_query_optimizer_info "timeout" record indicate?
During an investigation of some client machines losing their connection with SQL Server 2005, I ran into the following line of code on the web: Select * FROM sys.dm_exec_query_optimizer_info WHERE counter = 'timeout' When I run this query on our server - we are getting the following results: counter - occurrence - value timeo...
Best way to handle sql-connections in webservice?
I have a webservice that is called by up to 10 clients. The webservice is built up of 7 differnet asmx-pages and have about 100-200 functions in each page. All those functions are working against a MSSQL2005 or MS SQL2000 database. Some periods of the day its heavy traffic from the clients and it seems like I run out of connections on t...
SQL Server 2005 Generated Create Table Script not working.
I'm in the process of creating database scripts for an existing database. I'm trying to use SQL Server to generate the scripts for me, but the generated scripts are failing. I'm using the 'Script Table As'>'CREATE To'>'New Query Editor Window' option. I then change the table and constraint names and execute the script. I'm stumped. ...
How to develop a Windows scheduled task?
I need to have a process that compiles daily data into an PDF that will be attached into an email. I have already used MSSQL to send emails in the application being developed and would like to continue to use MSSQL as the email processor. In my research, I have found that this can be achieved by creating a Windows Service. But, since I ...
MISSING SERIES
Hi all, Im creating a stored procedure/function in MS SQL which should return the missing series. Example: the table "orders" contain field name "ordNo". ordNo 000001 000003 000005 the functions should return these values: 000002 000004 any idea? thank you very much. ...