Taggs

HI no17, is this for setting up a KMS client or KMS host? I am trying to setup a KMS host server. From what I read you should not need to specify a computer name and port number becuase I have already set this up in AD? Thanks Taggs

I have a mixure of SQL servers in my estate. SQL 2k5 on Win 2k3 SQL 2k5 on Win 2k8 SQL 2k5 on Win 2k8(shared Cluster server) SQL 2k8 on Win 2k8(shared Cluster server) I have set the memory allocation (max and min) for SQL server on each installation. When I looked at the memory allocation in Task manager on my SQL 2k5 on Win 2k3 and SQL 2k5 on Win 2k8 it shows the SQL service as using the allocated memory. When I look at the other SQL installs it shows as not using the allocated memeory. I started to do a little investigation and reading posts on the web people seem to think this is buffer memory allocation and does not show in task manager. I am quite willing to believe this but why do some of my servers show SQL is using the memeory (in task manager) and some show it is not? I can't see a corolation in SQL versions or OS versions! I do have PLIM set on my cluster but after looking into this I don't believe this has anything to do with it. Thanks Taggs

Hi, I am wondering if some one could help me please or at least point me in the right direction for KMS hosting. I'm "trying" to setup 2 KMS servers for my organisation. 100+ server 5000+ PC's I've setup the AD groups (for cross domain licening) I've configured DNS with the SRV records (plus permissions) I've then run the following commands slmgr.vbs /ipk xxxxx-xxxxx-xxxxx-xxxxx-xxxxx slmgr.vbs /ato SLMgr.vbs /SPrt XXXX (where xxxx is our new port number) I have also downloaded and setup KMS for Office 2010 (which seems to be working) My problem being if I try to install our KMS key from MS I get the following errors "The Software Licensing Service reported that the license is not installed" for my Windows Server 2008 Std/Ent KMS B key and "The software Licensing Service reported that the product key is invalid" for my Win 7 - KMS key (I've checked,checked and checked again and this is the correct key!) After trying all my keys the only one I have managed to get on (besides offce 2010) is Win Srv 2008 R2 Data Ctr/Itan KMS C This is driving me crazy as it should be so simple (or maybe it's just I'm so thick) My server is Win 2008 R2 and I have registered it with MS. Thanks Taggs

Hi gunsmokingman, Thanks for that but unfortunately I have already tried that but to no avail.

Hi Guys, I'm trying to perform an automated bulk insert of a file each day, which contains the date in the file name. If I enter the file name it runs fine so I think it is just the formatting of the code/string but I am struggling to find what it can be (if at all possible). The code extract is BULK Insert HDD_Info_temp from 'c:\support\bulkimport\HDD-REPORT-SUCCESS_' + (select convert(varchar,(CAST(CONVERT(varchar, GetDate(), 105) AS DateTime)),105)) + '-09-17-00.csv' with (fieldterminator = ',',rowterminator ='\n') go the error I get is Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '+'. Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '+'. if I run the statement select ('c:\support\bulkimport\HDD-REPORT-SUCCESS_' + (select convert(varchar,(CAST(CONVERT(varchar, GetDate(), 105) AS DateTime)),105)) + '-09-17-00.csv') I get the required string Any idea's or is it not possible via TSQL Taggs

OK I have a solution (from a post on another forum) The problem is USE looks for an Identifier The solution is exec('use ' + @database + '; <other statement/s here>) At the moment the job is reliant on the fact that the lodgical name is the same as the DB name My final code looks like this Declare @database_name varChar(50),@database_name_temp varChar(54) Declare database_name_CURSOR CURSOR FOR select name from sys.sysdatabases where dbid >4 order by name OPEN database_name_CURSOR FETCH NEXT FROM database_name_CURSOR into @database_name While @@FETCH_STATUS = 0 Begin Set @database_name_temp= @database_name + '_Log' exec('use ' + @database_name + '; DBCC ShrinkFile (' + @database_name_temp + ',10); Backup log ' + @database_name + ' with Truncate_only; DBCC ShrinkFile (' + @database_name_temp + ',10)') FETCH NEXT FROM database_name_CURSOR into @database_name End Close database_name_CURSOR; Deallocate database_name_CURSOR

Hi, I am trying to automate a Log Shrink File for all databases on our SQL Server (2005). I have a script that works to a fashion but I am having problems with one command. Declare @database_name varChar(50),@database_name_temp varChar(54) Declare database_name_CURSOR CURSOR FOR select name from sys.sysdatabases where dbid >4 order by name OPEN database_name_CURSOR FETCH NEXT FROM database_name_CURSOR into @database_name While @@FETCH_STATUS = 0 Begin Set @database_name_temp= @database_name + '_Log' Use @database_name DBCC ShrinkFile (@database_name_temp,10) Backup log @database_name with Truncate_only DBCC ShrinkFile (@database_name_temp,10) FETCH NEXT FROM database_name_CURSOR into @database_name End Close database_name_CURSOR; Deallocate database_name_CURSOR The problem is with the command Use @database_name the error message I get is Msg 102, Level 15, State 1, Line 8 Incorrect syntax near '@database_name'. If I substitute for a real Database name it works for that database (but no others obviously) Thanks Taggs