Viewing 15 posts - 4,831 through 4,845 (of 6,041 total)
prakashr.r7 (7/30/2013)
Eric M Russell (7/26/2013)
First, you can query INFORMATION_SCHEMA.COLUMNS to determine if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 30, 2013 at 6:45 am
Many client access libraries (ADO.NET and LINQ) support CRUD operations for XML. Also, starting with Windows 2008 / Vista, the NTFS file system supports transactional writes. So, an XML document...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 29, 2013 at 7:41 am
SQL Guy 1 (7/26/2013)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 29, 2013 at 7:10 am
🙂
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2013 at 8:42 am
I wouldn't even attempt to use SSIS to make daily copies of tables with schemas that can change daily.
First, you can query INFORMATION_SCHEMA.COLUMNS to determine if there have been any...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2013 at 7:33 am
My Lenovo laptop came bundled with something called VeriFace, which can substitute facial recognition for login password. It also appears to encrypt files and folders using using facial recognition. However,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2013 at 7:01 am
Luis Cazares (7/25/2013)
How about this?
SELECT TOP 1 *
FROM MyTable
ORDER BY DateOfBirth DESC
We also can't assume that DateOfBirth isn't nullable.
SELECT TOP 1 *
FROM MyTable
WHERE DateOfBirth is not null
ORDER BY DateOfBirth DESC
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 4:45 pm
Explain what it means to "get the person"; do you want to return the entire person row, just the person's ID, etc. ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 4:05 pm
Dird (7/25/2013)
Although currently I'm just looping through 11 servers and doing...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 3:57 pm
Dird (7/25/2013)
Oh I have this: http://www.mssqltips.com/sqlservertip/1037/system-information-in-sql-server-2000-vs-sql-server-2005My question was more whether anyone has done "CREATE VIEW sys.databases ...;" already or not~
Since your code needs to run against 2000 - 2008, perhaps...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 3:46 pm
I personally havn't had a need to do it, but since you have the inspiration, here is a link to get you started.
Mapping SQL Server 2000 System Tables to SQL...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 3:20 pm
Lowell (7/25/2013)
that should be easy to do , since everyone is logging...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 2:19 pm
Luis Cazares (7/25/2013)
Eric M Russell (7/25/2013)
In SSMS, you can right click an object and select 'View Dependencies'.
As far as I know, those dependencies are only within the database. If there...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 2:11 pm
This situation smells like Entity Framework. I'll bet it's developers telling management they need sysadmin membership in production or else the application won't work.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 2:06 pm
Sean Lange (7/25/2013)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2013 at 2:00 pm
Viewing 15 posts - 4,831 through 4,845 (of 6,041 total)