Search results for query: *

I am looking for some SQL to read the SQL Server Catalog and auto-gen DDL for Indexes? (joing sysindexes to sysobjects, etc) I don't just need the index name - I need the entire set of DDL for a given index. To be used to reCREATE indexes after I drop them and load a db w/ data. thanks for...

Does anyone have SQL which will auto-generate CREATE INDEX DDL using SQL's Catalog as it's data source? (I do NOT want to manually create the DDL using Enterprise Manager generate sql script) I have the need to DROP Indexes prior to loading large volumes of data. Then, dynamically recreating...

Receiving error message during the exection of my DTS Audit Task: "Variable uses an automation type not supported in VBScript" This Audit Task worked fine at my last client site (sourced directly from the SQL Server 2000 DTS Book from WROX) Here is the script - failing on line 55 (Note: I've...

Anyone know of a product / utility which will allow a user to selectively create SQL Scripts to build SQL objects? Our development team architect wants the capability to dynamically select any object (table, view, sp, etc) and generate script to be dynamically imbedded in his nitely deployment...

Experiencing a single table / single row Transactional Replication burp (processes & source/target DB's are in sync and operational) Details - under our Rep Monitor Agents / Distribution Agent I see: {CALL sp_MSins_tblMbrAssignments (2668927, 546264, 1, N'546264', 2004-12-21 00:00:00.000...

Within SQL 2000 Enterprise Manager, under Management I see the started (green arrow) SQL Server Agent icon w/ a small red circle (looks like a clock) over it. What does this indicate?

Need a suggestion (or prewritten proc/sql) to render all table names and their corresponding space allocations and usage for tables in a given Database. This renders all user table info: select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1 order by name Does anyone have...

- Have a UserID "FRED". - FRED registered SQL Server XYZ using SQL Server Authentication (specifying his UserID and PWD) - FRED is DBO on WIDGETS DB. - Whenever FRED creates a stored proc, the OWNER is showing up as FRED - FRED can create procs w/ DBO. prefix but the OWNER remains as FRED and...

Need a recommendation on SQL Profiler. I have a user stating he has a poor performing BIZTALK query. Generically asking, how can I capture the query? What SQL Profiler EVENT(s) (eg. TSQL, Transactions, etc) should I specify? What SQL Profiler DATA COLUMN(s) (eg. DatabaseID, etc)should I...

In SQL Server 2000 (sp3), does DBCC REINDEX physically LOCK the table? One DBA tells me it does, the other DBA tells me you can still execute queries against a table being REINDEXed.

For Snapshot Replication of source (PUBLISHED) tables containing IDENTITY columns, do I need to proactively do "anything" to ensure the propagation of these columns contents as is? In this table of 3 rows (ID values = 1,2,3) CREATE TABLE [dbo].[Application] ( [ID] [int] IDENTITY (1, 1) NOT...

My SQL 2000 DTS "Copy SQL Server Objects task" is loading tables I've deselected on the SELECT OBJECTS screen (NOTE: there are no dependencies between the objects I've UNchecked and the remainning objects) Characteristics of the Task "Copy" tab: SELECTED: Create destination objects, Drop...

Thoughts on the following: My SHRINKFILE on a Reporting DB consisting of 187 GB allocated, 100 GB used -- is taking several hours. I recently learned that after I restore the Reporting DB (from a prod DB backup) I can DROP 2 very large tables in the Reporting DB (occupying upwards of 80% of...

Just inherited a new SQL 2000 DB -- the nitely FULL Backup job has an imbedded step which references a server & directory called (see entire script at end of this note): \\CustDB\SQLBackups\FULL\Full_ApplData_01of04.bak' \\CustDB\SQLBackups\FULL\Full_ApplData_02of04.bak'...

When attempting to view a SQL Replication publication, I receive the message: "SQL Server does not support nicknames, such as "." or "(local)", as server names. Delete the SQL Server registration for this server and register it using the actual server name. While TERM SERVED on to this SQL...

I am relatively new to SQL 2K Replication (1 way transactional in this case). Receiving Integrity Check errors on 2 (of 5) source/publisher DB's. These 2 DB's are the only 2 (of 5) DB's w/ Replication activated on my SQL Server. (fyi, my distributor is on the same server as these 2 DB's) Has...

Using FP 2003, I recently set my home page to play music when the page is rendered. Unfortunately, when the user leaves the page to access another page on the site, the music stops! Is there a way to Keep the music playing as a user traverses the site? (www.MidniteBlue.net) thanks in...

I have a basic website done in MS FrontPage 2003 (www.midniteblue.net -- my bands site) In the left margin, I've created Hover Buttons w/ underlying links. These Hover Buttons appear on every page of the site. Some of my users complain that the Hover Buttons do not display - these users are...

Question... this query returns a summed value of a customers transactions (TransAmount): SELECT B.FirstName, B.LastName, C.CreditCardNumber, Sum(C.TransAmount) AS SumOfTransAmount FROM tblCustomers AS B, tblTransactions AS C WHERE B.SSN=C.SSN GROUP BY B.FirstName, B.LastName...

I need to install the Outlook Client on SQL Server 2000 for the purpose of allowing eMails to be sent. Does anyone have the Microsoft link handy which details the prep steps for this effort? thx!