Skip navigation
Menu

Microsoft's Sql Server Development Team

[email protected]

Changing a Column's Data Type
Dec 29, 2004
I have a table that contains more than 10,000 rows, and I want to change one column from a numeric data type to a float data type. How can I accomplish the change with the least impact on data availability...
Returning Only the Numeric Part of a String
Nov 22, 2004
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
Archiving User Activity
Oct 18, 2004
We have an application that requires us to log all user activity against a SQL Server 2000 database, then make the logs viewable online. We need to keep the activity logs for 7 years. We're expecting to capture about...
Explaining UserOrAlias Values
Oct 18, 2004
When I execute the sp_helplogins 'login name' procedure, it displays the value MemberOf in the UserOrAlias column. What does this value mean...
Tracking Auto-Growing Databases
Sep 20, 2004
How can I find out when a database has auto-grown? I'd like to know how often a certain database has automatically grown without any DBA intervention and, if possible, which files have auto-grown and to what size...
Remotely Installing a SQL Server Hotfix
Sep 20, 2004
Can I install a SQL Server hotfix via a remote desktop session from a Windows XP workstation, or do I need to be on the SQL Server system to install the hotfix...
Load More