101 reputation
4
bio website
location
age
visits member for 2 years, 6 months
seen Nov 10 at 15:13

Computer Programmer / Software Engineer.

I work primarily with ASP.Net (C# and VB) but also have quite a bit of experience with T-SQL and some client-side web technologies.


Nov
10
awarded  Commentator
Nov
10
comment How to update a CLR Assembly without dropping assembly from SQL Server
I'll to keep that in mind! I didn't realize I could provide a BLOB, though that might be how SSMS uploads my assemblies.
Nov
6
comment How to update a CLR Assembly without dropping assembly from SQL Server
I can use T-SQL for anything that does not require a file-system reference and is generally available to people with DBO rights on specific databases. Adding and Altering assemblies requires a file-system reference. A UNC path might work, but I'd have to mess with my machine's local firewall (assuming that corp security hasn't locked it down) and hope that SQL Server runs with a security context that can access my machine. The SSMS GUI can upload files from my machine to the remote server - so I can use it for adding assemblies.
Nov
6
comment How to update a CLR Assembly without dropping assembly from SQL Server
Yeah, that's what I thought. :( Perhaps a newer version of SSMS will allow updating assemblies from a remote machine. In the meantime, I guess I drop and create assemblies via the SSMS GUI -- and perform DROP and CREATE operations for all the dependent functions.
Nov
6
comment How to update a CLR Assembly without dropping assembly from SQL Server
Can this be done when the updated assembly is located on the SSMS client machine rather than the SQL Server host machine? I do not have sufficient privileges on the server to directly access its file system, but I do have sufficient rights to add and remove CLR assemblies.
Sep
24
awarded  Autobiographer
Aug
25
comment WS2008 subst in Logon script does not “stick”
This resolved my issue with the subst command. I had to use it with both my Admin and User tokens - which was a bit of a hassle...
Aug
25
comment WS2008 subst in Logon script does not “stick”
Although net use does not work for mapping local paths, if one were to share out a local path, net use could map to the local machine's share.
May
24
comment Calling LoadLibraryEx on ISAPI filter failed (v4.0.30319)
This fixed the issue for me. I think Microsoft needs to review their code and ensure they either don't include extra slashes in their built-in configuration settings, or else update their tools to treat doubled slashes as single slashes.
May
24
awarded  Supporter
Jul
25
comment Windows Server 2008: How do I configure a scheduled task to run with the logged on user's permissions?
However, I only have it running at log-on for just one of my accounts. I'll experiment a bit with groups and hope that the server/network group doesn't mind...
Jul
25
comment Windows Server 2008: How do I configure a scheduled task to run with the logged on user's permissions?
Yes, I've already found the "At Log On" trigger. :)
Jun
19
awarded  Tumbleweed
Jun
12
asked Windows Server 2008: How do I configure a scheduled task to run with the logged on user's permissions?