- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 4760
sp_password NULL,'new_password','sa' go
- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 4732
USE AdventureWorks GO SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%EmployeeID%' ORDER BY schema_name, table_name;From here
- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 5081
EXEC sp_MSforeachtable @command1 = 'select * from ?'
- Details
- Written by: Stanko Milosev
- Category: MS SQL
- Hits: 5180
If you are receiving error:
Invoke or BeginInvoke cannot be called on a control until the window handle has been created..
On new installation of MS SQL 2008 on Windows 7 64 bit, then try to download:
Cumulative Update Package 8 for SQL Server 2008
You don't need to have MS SQL Server installed.
Taken from here.