DECLARE @CityState VARCHAR(255)

SET @CityState='Herndon,VA'

SELECT

SUBSTRING(@CityState, 1, CHARINDEX(',',@CityState)-1) City,

SUBSTRING(@CityState, CHARINDEX(',',@CityState)+1, LEN(@CityState)-(CHARINDEX(',',@CityState)-1)) StateCode

Well, I had a small issue regarding writing a script to clean a database we have and reset its identity columns in all tables. Although the database wasn't huge one (less than 100 tables) I had to trace relations to be able to delete child table's records before parent's ones because of the foreign key constraints. The solution is disable the foreign keys and delete records with no fear of any errors then enables the constraints again.
Well, I found a solution to disable all constraints without the need to go on each table and disable it manually. and I was happy to know that I can use this solution in deleting all records from all tables. Not only this I was able to use the same solution to reset identity columns in all tables.
The solution was to use this built in stored procedure sp_MSforeachtable. For help about this proc search for it in Books online or use this sp_helptext sp_MSForeachtable.
Now back to my 6 lines, bellow is how I re-zeroed my Database:

/*Disable Constraints & Triggers*/
exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
exec sp_MSforeachtable 'ALTER TABLE ? DISABLE TRIGGER ALL'

/*Perform delete operation on all table for cleanup*/
exec sp_MSforeachtable 'DELETE ?'

/*Enable Constraints & Triggers again*/
exec sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
exec sp_MSforeachtable 'ALTER TABLE ? ENABLE TRIGGER ALL'

/*Reset Identity on tables with identity column*/
exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'

1. Verify that application is properly authenticating
1. Type known invalid credentials
2. Application should respond with an authentication error
1. If no response, verify machine can access Active Directory authentication source
2. Verify SQL native client is installed
1. Go to Control Panel\Administrative Tools\Data Sources (ODBC)
2. Click Add
3. Look for the driver "SQL Native Client" (near bottom of list)
4. Cancel
5. Install the SQL Native Client if missing from list found at:
   http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
1. http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli.msi for x86
2. http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli_x64.msi for x64

Make sure that your Pop-up Blocker is either turned off, or that you have allowed the Cognos URL

Add URL as a trusted site (you may need to uncheck “Require server verification (https:) for all sites in this zone”)

If you have "Custom Level.." security defined, ensure that you have enabled "Automatic Prompting for downloads"

Otherwise, you will get a pop-up window, the file will begin to download and it will be prevented by this setting.

When viewing in Excel formats, you should get a  dialog box that looks like this:

If you clear the “Always ask before opening this type of file” then the file should open directly in the pop-up browser window and you will not get this dialog box in the future.

Windows Vista delivers an impressive line up of network tools that can be used to keep the operating system connectivity on a short leash.Users will be able not only to closely monitor the networking activity of the platform, but also repair network connections. The utilities are not new to Windows Vista, having survived in the operating system from previous Windows versions.

1. getmac – this tool will enable you to display the MAC addresses for network adapters on a system. The Media Access Control (MAC) address for the network card can be accessed both on the local computer and on a network.

Syntax

getmac[.exe] [/s Computer [/u Domain\User [/p Password]]] [/fo {TABLE|LIST|CSV}] [/nh] [/v]

Examples

he following examples show how you can use the getmac command:

getmac /fo table /nh /v
getmac /s srvmain
getmac /s srvmain /u maindom\hiropln
getmac /s srvmain /u maindom\hiropln /p p@ssW23
getmac /s srvmain /u maindom\hiropln /p p@ssW23 /fo list /v
getmac /s srvmain /u maindom\hiropln /p p@ssW23 /fo table /nh

2. hostname – not sure about what the name of your machine is on the network.Just type hostname and hit enter.

Syntax

hostname

Examples

To display the name of the computer, type

hostname

3. ipconfig – according to Microsoft’s own description, the tool is designed to display by default only the IP address, subnet mask and gateway for each adapter associated with the TCP/IP. But in addition to enumerating the TCP/IP network configuration parameters users can also refresh the DHCP and DNS settings.

Syntax

ipconfig [/all] [/renew [Adapter]] [/release [Adapter]] [/flushdns] [/displaydns] [/registerdns] [/showclassid Adapter] [/setclassid Adapter [ClassID]]

Examples

To display the basic TCP/IP configuration for all adapters, type:

ipconfig

To display the full TCP/IP configuration for all adapters, type:

ipconfig /all

To renew a DHCP-assigned IP address configuration for only the Local Area Connection adapter, type:

ipconfig /renew “Local Area Connection”

To flush the DNS resolver cache when troubleshooting DNS name resolution problems, type:

ipconfig /flushdns

To display the DHCP class ID for all adapters with names that start with Local, type:

ipconfig /showclassid Local*

To set the DHCP class ID for the Local Area Connection adapter to TEST, type:

ipconfig /setclassid “Local Area Connection” TEST

4. nslookup – is meant to be used according to Domain Name System.

5. net – is a general tool with commands covering a broad range of functionality.

6. netstat – displays protocol statistics and TCP/IP network connections.

Syntax

netstat [-a] [-e] [-n] [-o] [-p Protocol] [-r] [-s] [Interval]

Examples

To display both the Ethernet statistics and the statistics for all protocols, type the following command:

netstat -e -s

To display the statistics for only the TCP and UDP protocols, type the following command:

netstat -s -p tcp udp

To display active TCP connections and the process IDs every 5 seconds, type the following command:

nbtstat -o 5

To display active TCP connections and the process IDs using numerical form, type the following command:

nbtstat -n -o

7. netsh – the command-line tool enables Vista users to both view and alter the network configuration settings of computers.

8. pathping – is a middle solution which bundles the functionality delivered by traceroute and ping.

Syntax

pathping [-n] [-h MaximumHops] [-g HostList] [-p Period] [-q NumQueries [-w Timeout] [-T] [-R] [TargetName]

Examples

The following example shows pathping command output:

D:\>pathping -n corp1

9. nbtstat – a tool that will display protocol statistics and current TCP/IP connections using NetBIOS over TCP/IP.

Syntax

nbtstat [-a RemoteName] [-A IPAddress] [-c] [-n] [-r] [-R] [-RR] [-s] [-S] [Interval]

Examples

To display the NetBIOS name table of the remote computer with the NetBIOS computer name of CORP07, type:

nbtstat -a CORP07

To display the NetBIOS name table of the remote computer assigned the IP address of 10.0.0.99, type:

nbtstat -A 10.0.0.99

To display the NetBIOS name table of the local computer, type:

nbtstat -n

To display the contents of the local computer NetBIOS name cache, type:

nbtstat -c

To purge the NetBIOS name cache and reload the #PRE-tagged entries in the local Lmhosts file, type:

nbtstat -R

To release the NetBIOS names registered with the WINS server and re-register them, type:

nbtstat -RR

To display NetBIOS session statistics by IP address every five seconds, type:

nbtstat -S 5

10. Ping – Verifies IP-level connectivity to another TCP/IP computer by sending Internet Control Message Protocol (ICMP) Echo Request messages. The receipt of corresponding Echo Reply messages are displayed, along with round-trip times. Ping is the primary TCP/IP command used to troubleshoot connectivity, reachability, and name resolution.

Syntax

ping [-t] [-a] [-n Count] [-l Size] [-f] [-i TTL] [-v TOS] [-r Count] [-s Count] [{-j HostList | -k HostList}] [-w Timeout] [TargetName]

Examples

The following example shows ping command output:

C:\>ping example.microsoft.com

Pinging example.microsoft.com [192.168.239.132] with 32 bytes of data:

Reply from 192.168.239.132: bytes=32 time=101ms TTL=124

Reply from 192.168.239.132: bytes=32 time=100ms TTL=124

Reply from 192.168.239.132: bytes=32 time=120ms TTL=124

Reply from 192.168.239.132: bytes=32 time=120ms TTL=124

To ping the destination 10.0.99.221 and resolve 10.0.99.221 to its host name, type:

ping -a 10.0.99.221

To ping the destination 10.0.99.221 with 10 Echo Request messages, each of which has a Data field of 1000 bytes, type:

ping -n 10 -l 1000 10.0.99.221

To ping the destination 10.0.99.221 and record the route for 4 hops, type:

ping -r 4 10.0.99.221

To ping the destination 10.0.99.221 and specify the loose source route of 10.12.0.1-10.29.3.1-10.1.44.1, type:

ping -j 10.12.0.1 10.29.3.1 10.1.44.1 10.0.99.221

11. route – manipulates network routing tables.

Syntax

route [-f] [-p] [Command [Destination] [mask Netmask] [Gateway] [metric Metric]] [if Interface]]

Examples

To display the entire contents of the IP routing table, type:

route print

To display the routes in the IP routing table that begin with 10., type:

route print 10.*

To add a default route with the default gateway address of 192.168.12.1, type:

route add 0.0.0.0 mask 0.0.0.0 192.168.12.1

To add a route to the destination 10.41.0.0 with the subnet mask of 255.255.0.0 and the next hop address of 10.27.0.1, type:

route add 10.41.0.0 mask 255.255.0.0 10.27.0.1

To add a persistent route to the destination 10.41.0.0 with the subnet mask of 255.255.0.0 and the next hop address of 10.27.0.1, type:

route -p add 10.41.0.0 mask 255.255.0.0 10.27.0.1

To add a route to the destination 10.41.0.0 with the subnet mask of 255.255.0.0, the next hop address of 10.27.0.1, and the cost metric of 7, type:

route add 10.41.0.0 mask 255.255.0.0 10.27.0.1 metric 7

To add a route to the destination 10.41.0.0 with the subnet mask of 255.255.0.0, the next hop address of 10.27.0.1, and using the interface index 0×3, type:

route add 10.41.0.0 mask 255.255.0.0 10.27.0.1 if 0×3

To delete the route to the destination 10.41.0.0 with the subnet mask of 255.255.0.0, type:

route delete 10.41.0.0 mask 255.255.0.0

To delete all routes in the IP routing table that begin with 10., type:

route delete 10.*

To change the next hop address of the route with the destination of 10.41.0.0 and the subnet mask of 255.255.0.0 from 10.27.0.1 to 10.27.0.25, type:

route change 10.41.0.0 mask 255.255.0.0 10.27.0.25

12. tracert – users can implement this command-line tool to identify connectivity problems between the local computer and a network address.

Syntax

tracert [-d] [-h MaximumHops] [-j HostList] [-w Timeout] [TargetName]

Examples

To trace the path to the host named corp7.microsoft.com, type:

tracert corp7.microsoft.com

To trace the path to the host named corp7.microsoft.com and prevent the resolution of each IP address to its name, type:

tracert -d corp7.microsoft.com

To trace the path to the host named corp7.microsoft.com and use the loose source route 10.12.0.1-10.29.3.1-10.1.44.1, type:

tracert -j 10.12.0.1 10.29.3.1 10.1.44.1 corp7.microsoft.com

When using command-line tools in Windows Vista it is healthy to remember to launch the command prompt window with administrative privileges. In order to do so, enter “cmd” in the Search box under the Vista Start Menu and press Ctrl + Shift + Enter to launch the process with elevated privileges.

1. Open Control Panel
2. Double-click Scheduled Tasks
3. Double-click Add Scheduled Task
4. On the Scheduled Task Wizard dialog, click Next
5. Click Browse
6. In the Select Program to Schedule dialog, navigate to the windows\system32 folder
7. Select defrag.exe
8. Click Open
9. In the Scheduled Task Wizard dialog, type a name for the scheduled task (Disk Defragmenter, for instance)
10. Under Perform this task, select how often you wish Disk Defragmenter to run
11. Click Next
12. Set the time at which you wish the Disk Defragmenter scheduled task to run.  This should be a time when your computer is on, but not in heavy use.
13. Select the frequency at which you want the Disk Defragmenter scheduled task to run (Every Day, Weekdays, or Every <N> days, where <N> is the number of days between scheduled runs)
14. Click Next
15. Enter a user name under which the Disk Defragmenter scheduled task will run.  Note: This user must be an administrator on the local machine.
16. Enter the password for the user you entered in the previous step
17. Confirm the password for the user
18. Click Next
19. Check Open advanced properties for this task when I click Finish
20. Click Finish
21. In the Run text box, you should see the full path and command for defrag.exe.  By default, this path is C:\WINDOWS\SYSTEM32\defrag.exe
22. Append the drive letter for the drive you wish to defragment to the command in the Run text box.  In a default installation, your Run command will look like this:
            C:\WINDOWS\SYSTEM32\defrag.exe C:
23. Click OK
24. In the Set Account Information dialog, enter and confirm the password for the user listed in Run as
25. Click OK
     
    Disk Defragmenter will now run as the specified user on the schedule you specified when you created the scheduled task.

We need to change the query parameters in the ADAM service.

1.  Log into server with ADAM instance using an account with the proper permissions
2. Go to the ADAM Tools Command Prompt
3. Start the dsmgmt tool  (note ? will display options)
4. Get into the LDAP policies section
5. Connect to the ADAM service (and quit to return to theLDAP policies prompt)
6. Show values, set MaxPageSize to <new value>
7. Show values again to verify new value
8. Commit changes
9. Quit out of ldap policy and out of dsmgmt tool
   

When an “export to LAE” fails due to incomplete result set:

In the LAE log file:

The operation failed because the directory server cannot return the complete result set. 

For more information, consult your directory server documentation on how

to increase the maximum number of results that can be returned from the function ldap_search.

If your user base starts to grow rapidly you may encounter errors/warnings about not enough available database connections to run a report/query/etc.

..c8/bin/CQEConfig.xml

 From: <entry name="PoolSize" value="20"/>
 To:     <entry name="PoolSize" value="50"/>