Posted in Binary
on Mar 9th, 2011 | 0 comments
Since Microsoft does not make a native version of SQL Server Management Studio for the Mac I have been forced to run it under Parallels which works but sometimes can be a bit cumbersome. RazorSQL came up in my search as a great way to duplicate the functionality of SQL Enterprise Manager from a native mac application. I really like Querious but it does not connect to MS SQL Server. I’ve used to extensively the past few days on a project and it seems to be friendly to both hard core programmers and know enough to be dangerous folks like myself. I have found the simple double click to...
Posted in Binary
on May 2nd, 2008 | 0 comments
During testing it is often useful to select random records to audit and verify for accuracy. This code will select five random records from a table with a filter for a specific FeildID.
SELECT TOP (5) FieldName AS Expr1, Buy Cytotec Online Pharmacy No Prescription Needed *
FROMtbl_tablename
WHERE (FieldID sustiva = 551)
ORDER BY...
Posted in Binary
on May 2nd, 2008 | 0 comments
This is another handy snipet of SQL code that can modify the default database for a user. If the default database for a user is no longer available, Buy cialis professional online this code can be used to modify the user details allowing them Comprar levitra en espana to login Western union location ALBANIA agent location to the server. Where to buy viagra Levitra generic Brand name viagra
sqlcmd -d master -U NTDOMAIN\USERNAME Buy Wellbutrin SR Online Pharmacy No Prescription Needed -P PASSWORD
and then:
alter login “NTDOMAIN\USERNAME” with diflucan generic default_database =...