Get all FKs with their table names, PK/FK fields
Upon closer inspection your query returns too many results since the ordinal position of the field is not taken into account. The following SQL is correct: SELECT FK_Table = fk.table_name, FK_Column = fkc.column_name, PK_Table = pk.table_name, PK_Column = pkc.column_name, constraint_name = fk.constra... 21 Jun 2010 04:48
SQL Server administration scritpts for a new server?
I would appreciate if someone can guide me on where I can find useful administration scripts (daily, weekly, monthly, etc) I can setup for a news server. Also let me know if any performance related scripts I can run to get recommendation for improvement, etc. ... 20 Jun 2010 15:40
How to check that the Cursor is on the last row?
Is there an easy way to check that the cursor you're fetching through is on it's last row? I can get the rowcount, but I don't want to select count(*) from the table. ... 21 Jun 2010 21:25
delete a record
I am having records just disappear. Is there a way of telling when they were deleted and maybe by whom? Does transaction log give this information? ... 22 Jun 2010 17:10
sql server name instance
hi is sql 2005 named instance is same as sql server virtual server? ... 18 Jun 2010 16:52
How to Call an SSIS package from SQL-server.
Hello All, From a stored procedure I would like to call an SSIS package. I have two packages: 1. Does an FTP call to a legacy system to collect information and put this in a local file as .csv. 2. Process a number of local .csv files, get the information in a import table then process the import table. I hav... 18 Jun 2010 12:27
MS SQL Server 2005 hang
Hi, Did you get any solution to your problem. I'm experiencing the same kind of problem on one server with 16GB memory and a partitionned table... My SELECT (even very simple one) will freeze from time to time even if I'm the only one connected to the database. The same query will need one second to execute and w... 18 Jun 2010 17:59
Permissions Needed to Count SSB Transmission Queue Messages
Hi, I'm trying to figure out a way for a monitoring app to count messages in our transmission_queue. We want the app to alert us if it's over X number of messages. As it is now, giving the account db_reader perms, it doesn't even return an error. It returns 0, which is odd. It seems that giving sysadmin privil... 25 Jun 2010 18:41
SQL 2008 R2 is not let to login with one of login ID
Hello, I have SQL 2008 R 180 installed as default instance on my laptop. Access is mixed mode When I log into my laptop as administrator, I can login using sa without any problem But when I login as a different User ( with admin rights) , SSMS does not let me log in using sa or Windows authentication. Any ... 19 Jun 2010 22:11
The performance counter registry hive is corrupted
Hi I have windows 2003-X64-enterprise with all the updates and I was trying to install SQL 2008 (R2_enterprise_x86_x64_ia64), and I got the performance counter registry hive is corrupted (the performance counter registry hive consistency failed ) Any advice? Thanks ... 17 Jun 2010 15:40