Ok Few things you need to consider. 1) Makes sure that Excel file has clearing columns defined. 2) Do you have a table in SQL to where you want to...
I am trying to understand if I can do the following. Let's say there are 10 user in my Active Directory. I created a Group called - "Manager" and...
I am trying to do the following : For example : I have a String "This is Jack" I want to do a while loop where it will check for the ' ' (space)...
You can run the query based on ID. For example for ID# 2 ,You can do something like this : SELECT...
Does the change values changes the values of that row or it add a new entry?
I tried to use SET ROWCOUNT but no luck. Has anyone ever tried to create a linked server to Active Directory and then run a query of that linked...
If you have XML file Result set then InfoPath will sort it out for you. All you have to do is connect to the query through InfoPath. You can to it by...
Yeah I am sure that it is more than 10000 rows but the query analyser only returns max 10000. I am query Active Directory through SQL Server.
I am querying users from Active Directory but my results only give me 10000 rows. How can I get all the rows? Thanks.
I want to create a Stored Procedure that will check a field from one table and check it in my Active Directory. I have linked server for AD. Is...
Can anyone suggest me any books about DBA stuff. I am ok with backup and restore stuff but still need to get use to dba commands. Thanks.
Thanks for the reply. So is it ok to run SHOWCONTIG on user tables and then try to reindex them if it is necessary? Thanks.
Hello: I am fairly new DBA. I wanted to know how can I reindex system tables. I ran SHOWCONTIG and noticed that the density is quite low on them so...
Separate names with a comma.
