Posts
Sort by recent activity
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...
Backup step not included in script
When I use SQL compare to do the comparsion, I see there is an option to do the database backup.
But the script generated doesn't include backup script.
Is anywhere I can generate a backup script i...
generate database schema
Is there a way in SQl Compare to generate database schema for an exisitng database?
Thanks