SqlServer-QA.net

This was the big question posed by the users when a migration project is initiated at one of client's place.   SQL_Server_Migration_Assistant is a must tool to asses the issues when you have a mammoth task of data migration between SQL Server and other data sources such as Oracle & SYBASE. You may not know that not all Oracle ...

As you may be aware that you can pass parameters to the stored procedure when you have the selection of data requirement such as stored procedure with data type,length, parameter position and also the mode of parameter (Input or Output). Using INFORMATION_SCHEMA views you can get further information on what kind of parameters are used within a ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: ''A stack overflow occurred in the server while compiling the ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: ''BCP host-files must contain at least one ...

It may not be a hardcore requirement on day-to-day basis to drop all tables, views and stored procedures from a SQL Server database within your environment, but it will be handy to have such a code at your end when such task is required. There are 2 ways to accomplish this, first using undocumented stored procedure such as ...

If you are Developer then debugging your own code is an usual practice and when you got used to perform the same on SQL Server 2000 version, it is not an easy way in SQL Server 2005 version. As you may be aware that SQL Server 2000 engine includes a debugger for stored procedures and not within SQL Server 2005. The alternative to this process ...

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual practice of checking of whether its a security issue to allow the logins, if so then goto ...

They say better not to use UNDOCUMENTED stored procedures, which is true in the aspect when any Service Pack or version is released that may not be included and your task might have issues in working out. Similar to this I was going through various methods to get information on login mapping name since SQL Server ...

USE <database_name>; GO SELECT SCHEMA_NAME(schema_id) AS schema_name ,o.name AS object_name ,o.type_desc ,p.parameter_id ,p.name AS parameter_name ,TYPE_NAME(p.user_type_id) AS parameter_type ,p.max_length ,p.precision ,p.scale ,p.is_output FROM sys.objects AS o INNER JOIN sys.parameters AS p ON o.object_id = ...

Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system.   On the system with SQL 2005 Service pack2 when executing this ...