Search results for query: *

Has anyone installed SP5 yet? http://www.microsoft.com/smserver/downloads/20/servicepacks/sms20sp5/default.asp Any success or horror stories?

Out of curiosity, who in the Tek-Tips crowd is headed to MMS? http://www.microsoft.com/management/mms.asp http://www.mms2003.com/ http://www.myitforum.com/forums/tt.asp?appid=15 snyderj

Does anyone have a simple script to allow or deny running an executable? snyderj

Does anyone have examples or suggestions on use of GetEffectivePermission through vbscript?

I'd like to start a discussion for us to share information about SMS 2 client health maintainance. I bet each of us has some trouble with clients with bad WMI repositories, old hardware scans (while software is current), oddball status messages, connecting to incorrect sites, dropping out of...

Have any of you run across a conflict between Remote Desktop 32 (Network Associates product) and SMS 2 SP4? If RD32 exists then SMS2SP4 is installed, when the system sleeps it freezes the mouse. Even a reboot doesn't fix it. If RD32 doesn't pre-exist then there isn't a problem. Any ideas are...

Anyone know what this error indicates? It occurs sometimes (not always) when running simple queries in Access 2000 against a WBEM ODBC linked table. ODBC--call failed. [Microsoft][WBEM ODBC Driver]Conversion error (#1009) Thanks.

Currently I have a SQL agent on SERVER1 performing the following example daily task to copy selected data from one server to another: SELECT IDENTITY (int, 1, 1) AS RowID, view1.*, 'XYZ' AS SourceSvr INTO database.dbo.table1 FROM [SERVER2].database.dbo.view view It seems that using stored...

I've read the numerous Tek-Tips upsizing responses and FAQs, which have been helpful, thank you. Now onto the next stage: seeking URLs and reference books for complex upgrades to SQL 2K (which may mean re-building from scratch). The Access 2K db in question has outgrown its britches by a long...

Any recommendations for getting the SP4 HRP on a secondary site? Going to the site is not a viable option. A terminal server session is possible but not practical.

I want to create an "alias" for tables on a linked server but have not been able to determine the proper syntax. I thought that something such as what's below would work through Query Analyzer (while logged into server 1 with [VirtualServer\Instance] as a linked server), but the...

Is there a command in SQL Server 2K similar to Excel's REPT command? I'm thinking of something such as: 'ABC' + REPT(0,10-LEN(@variable)) + @variable so that ABC123 becomes ABC0000000123. Thanks.

I have a statement such as SELECT IDENTITY (int, 1, 1) AS RowID INTO ... that works just fine. Now I want to prepend a literal to it. I thought that SELECT 'XYZ' + IDENTITY (int, 1, 1) AS RowID INTO ... would work but I get a syntax error. I tried using CAST and CONVERT around the IDENTITY...

What's a good way to create a sequential autonumber through a SQL Server view? Specifically, can I do this through a SELECT ... INTO ... (perhaps using CAST?) or do I have to first CREATE TABLE with IDENTITY(1,1)? (BTW, NEWID() creates a GUID that's too long for the customer.) Thanks for any...

I've noticed that folks (including myself) in this forum have not rated answers as "helpful" in recent months (magenta stars). The last star rating I saw was three months ago. What's up with that? I can blame myself too for not giving out stars, even though I've seen quality answers...

I want to copy a SQL Server Agent job (with TSQL type steps) from server A to server B. When I do these steps: - Click on the job I want to copy - Select All Tasks then Generate SQL Script - Enter a file name - Click OK I get the error: "A job step's command contains the TSQL Batch...

Server 1 and Server 2 each have a table called X. I establish an ODBC connection in Access to Server 1 table X and call it 1X, and to Server 2 table X and call it 2X. Question: is there a way in Access to verify that 1X is really connected to Server 1 table X? I don't see anything useful (such...

I'm using a Kensington Expert Mouse trackball on XP. Even with the fastest mouse settings through control panel the mouse is still quite slow. I've found some registry settings but adjustments don't help. I don't want to install the Kensington driver since it doesn't pass through Terminal Server...

Anyone know how I can easily turn on and off the bottons on the top of my IntelliType Pro keyboard? (These are the buttons for internet hot keys, mail, and sound.) My toddler likes to press these buttons while playing computer games and he gets popped out of his application. Thank you.

What SMS 2 data dictionary options are available? I'm specifically looking for table and field descriptions, not element types and sizes. I've found that the SMS 2.0 Resource Guide (out of print) is a good resource, but it's only on paper. The MS site...