Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.
2007-10-02 (first published: 2004-06-02)
47,941 reads
2004-10-29
2,674 reads
If we give SP_HELP , we'll know to which File Group the table belongs.If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group. But have you ever tried that, given a file group, how to find all the tables that belong […]
2004-05-10
137 reads
It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
2002-09-19
329 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
The Utah Jazz experienced arguably their utmost modern acquire of the year in excess...
No person would create the situation that a eye-catching video game of basketball was...
Chicago Bulls vs. Charlotte HornetsCharlotte, North Carolina; Wednesday, 7:30 p.m. ESTBOTTOM LINE: Charlotte is...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers