:::: MENU ::::

Posts Categorized / SQL Server tools

  • Nov 12 / 2008
  • 0
DBA Interview questions, dbDigger, Logins and Users, SQL Server tools

Change password with -Z parameter through SQLSMD

Question: You are trying to run some scripts using SQLCMD but keep getting errors that your password has expired. SSMS is not installed on this machine. What should you do?

Answer: Use the -Z parameter to change your password.

Explanation: While many of us might feel like going home, that’s not a great solution. Either calling a DBA or finding another workstation will work, but that’s inefficient. With the -Z parameter, you can change your own password with SQLCMD.

Ref: SQLCMD – http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx

Note: The Question is taken from SQLServercentral.com.

  • Oct 31 / 2008
  • 0
dbDigger, SQL Server tools

Security requirements for running profiler in SQL Server 2008 for compatibility mode 80 database

Question: In SQL Server 2008, if you are running Profiler in a database set to compatibility mode 80, are the security requirements for showplan data determined?

Answer: The SQL 2008 interpretation is used.

Explanation: When you view showplan information through Profiler and the database compatibility mode is set to 80, the SQL Server 2008 permission interpretation is used. In this case, the compatibility mode has no effect.

Ref: Showplan Security –

Note: The Question is taken from SQLServercentral.com.

  • Jul 17 / 2008
  • 0
dbDigger, SQL Server tools

SQL Server 2005 tableDiff utility

TableDiff is one of many command line utilities in SQL Server 2005. It helps to determine differences between tow tables or views. One of these is taken as source and other as destination. This utility can report differences on schema and data. Although this utility is primarily designed for comparing replicated tables, but we can use it to compare tables.
To invoke the utility. Go to command prompt and access com folder of SQL Server 2005 installation there.

Then entered following command to compare tables through this utility.The command takes a few basic parameters to run.

  • sourceserver
  • sourcedatabase
  • sourcetable
  • destinationserver
  • destinationdatabase
  • destinationtable

Here tablediff is key word to invoke the functionality. All words starting with – are reserve words and are self explainatory. All words between the quotes are in your parameters and are linked to ancestor word starting with -. As you enter this whole command your parameters are echoed and result of comparison is generated.
Another powerfull feature is generation of SQL Scripts for the differences that it found between two tables. For that u just have to add -f as additional flag and also have to provide path and name for script.

Other options can be used in the TableDiff Utility. They can be found by executing the following command:
C:Program FilesMicrosoft SQL Server90COM>tablediff /?

Consult us to explore the Databases. Contact us