Posts
Sort by recent activity
how to unselect some options in SQL doc
For generate SQL doc, my purpose is to create a data dictionary, I only need to show the table name, column name and MS_description.How can I elminate the column data type, max length, nullablility...
MS_Description
After I generate the SQL doc, since most of our ms_description is empty, I would like a business writer who knows more about the metadata and knows how to define the tables and columns in a busines...
Database dictionary
I have a SQL server database, I would like to create a data dictionary, that basically explains what the table and its columns definition. What production should I use to help the process?Thanks
uninstall
I accidently installed SQL source control which I don't need it.How can I uninstall it? THanks
SQL search icon not showing up in SSMS v17.4
I tried to install SQL search 3 on SSMS v 17.4. It says intallation completed.
But I cannot see the icon shows up on the top of the screen, it is not available.
I installed SQL prompt, it shows up....
Does SQL search work on schema besides dbo schema?
I have SQL search 2.4 installed. I tried to search an object in a database that has only schema other than dbo, but I cannot find anything even that object exists in the schema.
Does SQL search onl...
SQL prompt with management studio version
I use SQL prompt in my SQL 2008 management studio, now I installed SQL 2012 management studio, SQL prompt is not available.
how can I make SQL prompt avialble to both version of SSMS on my compute...
trace 3604
I have a DBCC traceon (3604) and DBCC traceOff (3604)
in SQL log on my developer machine.
I did a profiler trace and found out it is from Redgate SQL Prompt 5.1.8.2.
Is that normal?
Why it needs so...
synchronization script
I use SQL compare to compare my dev database with production.
Since I only modify a column 's length to a table, it shows the table schema is different, and all is fine until I get to the generate ...
SQL Compare synchronize script issue
I generated a scipt that synchronizes the testing database with production database.
Most of time the script works fine. But sometimes the script runs with errors. An example in the script, it alte...