View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 [29] 30 31 32 33 34 35 36 37

  1. Database change tracking software
  2. Updating tables via agent ?
  3. Erro trapping question
  4. Enterprise Manager Job Scheduler Vrs Query Analyzer???
  5. Problem with date
  6. Where to put ISNULL
  7. pocket pc mssql remote database admin
  8. Select in a transaction hangs when selecting from remote table
  9. AD
  10. Sparse Hierarchy T-SQL Help...PLEASE?
  11. No triggers, constraints
  12. No triggers, constraints
  13. EM - Open table - Return Top... -1000
  14. How to Identify Permissions for SQL Server Tables & Stored Proc. via VB Code
  15. Command works in DOS but not in xp_cmdshell
  16. Connecting to SQLServer 2000 using DNS alias
  17. export from mssql database
  18. Reordering entries in form
  19. Is this possible?
  20. Help! Dates and SQL
  21. Tables and Stored Procedures
  22. How Is The SQL2000 Desktop Licensed?
  23. Help needed with Backup and Restore
  24. Access a table
  25. Lock/block retained after commit
  26. Owner of the table
  27. Select returns one row from two
  28. Problem shrinking a database
  29. Table Name in Variable - Create Statement
  30. Is there an easy way to monitor (audit) who logs onto a database ??
  31. Is Yukon Beta2 download scalable up to 8 CPUs
  32. SQL Server 2000: How to handle licenses?
  33. MS GRAPH, PASSING PARAMETERS, ACCESS PROJECT
  34. Access crashes when updating a stored procedure
  35. SQL Server 2000: not enough storage is available to complete this operation
  36. Next Run Date column not sorting
  37. Application Performance advice please?
  38. Logging Errors
  39. how can i manage database on lan base[network base]software
  40. Recover Master database fron only MDF file
  41. Use a downloaded database
  42. Primary Key: I am trying to understand--please help if you can.
  43. SQL Server takes too long to run a query
  44. [MSSQL + VS.NET] Connection - sleeping
  45. Sql Server to MSDE - good choice?
  46. how do i use select statement in update query
  47. Trigger code
  48. ASP / SQLServer connection
  49. how to use select statement in insert query
  50. String searching
  51. how do i connect from one sqlserver7 to other sqlserver7 through internet
  52. Optimizing Database
  53. How to get back the value from exec() ?
  54. Change owner
  55. SQL Server Chat next Tuesday: SQL Server 2005 Beta 2 CLR Q & A
  56. Nulls being allowed when they shouldnt be?
  57. bcp API
  58. Variable in Variable
  59. Backup to remote pc
  60. Active Script OK But Scheduled Job Fails
  61. Reporting Services: Role Assignment without using Report Manager
  62. Vchar vs Char
  63. dynamic killer
  64. Removing non-printing characters ...
  65. Changing Column Name on a table
  66. Regex parser Text field
  67. Current user
  68. Desperate! - Need simple MSSQL server monitoring scripts, ideas, etc that can be performed by operator types (non-programmers)
  69. Relationships getting deleted (MS SQL)
  70. creating trigger to auto set create/modify dates
  71. Error when writing to SQL server through asp page using windows authentication
  72. Transaction through stored Procedure
  73. SQLServer 2005 Beta
  74. limit the access
  75. Indexed Views Vs temp tables
  76. how do you know what transation ID to play forward after restore?
  77. Search Text in Database
  78. audit select on a table?
  79. Log file of test database bloating
  80. Compare two column values with leading zeros
  81. Dynamic SQL and function
  82. Lookup value query joining two tables
  83. odbc sql server driver timeout expired
  84. auditing logins in Analysis server
  85. problems registering new database with EM.
  86. MS SQL Server client under linux/unix.
  87. Adding a day to a date.
  88. Basic SQL Server Question
  89. reporting on a DTS performance reporting
  90. Hiding Data
  91. View Users
  92. Restore DB procedure - date parameter
  93. password hash
  94. Transposing
  95. how to monitor for full table scans?
  96. DBA Responsibility
  97. DECODE in SQL Server?"
  98. Lookup value query joining two tables
  99. urgent - data type problem
  100. Populating an Access combo box with large amount of data causes table lock in SQL Server
  101. Periodic maintenance like sp_delete_backuphistory?
  102. SQL Server 2000 on AMD
  103. DTCXact transaction in DBCC openTran
  104. selecting the latest date from different columns
  105. Help Trigger
  106. URGENT database security question
  107. Data model for a web messaging application.
  108. Change local variable inside query
  109. transform recordset
  110. Update sql syntex question
  111. Text column slows down select
  112. Average Computation Question
  113. Mapping image pointers to page numbers
  114. See the good, the bad, and the ugly of your SQL Server data with OneClickRevelation(tm)
  115. Update Statistics failed, incorrect set options
  116. Temp DB growing to max available disk space
  117. Manual Log shipping
  118. SQL SERVER SMP configuration
  119. invalid object like view, function etc.
  120. invalid object like view, function etc.
  121. Creating view (transpose records to columns)
  122. Data Replication performance.
  123. saving changes made to database
  124. Transact SQL probklems with variable scope
  125. Book recommendation
  126. tran log reader/viewer
  127. Restoring the master to different drive letters
  128. sorting string
  129. DTS -- SQL Server Data to AS400
  130. Help - Server stops responding to connections, stops accepting connections
  131. run 3 dynamic selects from stored proc
  132. Group by on the text colum throws error
  133. SQL Server Service Account
  134. Query returning duplicate field names
  135. Can SQL Server 2005 Express and SQL Server 2005 be installed on same machine?
  136. Export data from SQL2000 to XML
  137. Backup Disabling Randomly
  138. Table size count
  139. Converting a smallint to an nvarchar
  140. Analsis Manager Parent-Child missing Writeback in Select Advanced Options
  141. How to configure sql server
  142. Firing Triggers from 1 SQL Server to another
  143. Is there a way we can implement business logic by storing it in colums of a table and calling it?
  144. database architecture and table design
  145. Second instance creation tiny wittle problem?
  146. Transposing rows into columns
  147. Stop time duration problem
  148. openrowset drivers msdaora
  149. Create query based on a field that won't be the same value in both tables
  150. 2 sql servers with Access Front-end
  151. Recommended method to obtain SQLDataPath
  152. random row
  153. Backup transaction logs and replication simultaneously
  154. Authors and Instructors Needed!
  155. Stored procedure performance optimization
  156. Another question (IN keyword)
  157. MSSQL acting strange
  158. Need to Change Developers Acct to Windows Authentication
  159. How to find the size of the database dump.
  160. Problem with a foreing key
  161. Follow-up: DTS question
  162. Problem with SQL generated from MS Access
  163. Hanging or lockup issue with SQL Server and Terminal Services 2000 on NT 4 Domain Server
  164. server heartbeat function
  165. Internal SQL Server error when using variable
  166. log shipping - out of sync
  167. Changing datatype from char to datetime
  168. strange performance
  169. SA to Windows Authentication
  170. sql books
  171. DTS global variable question
  172. Database Design
  173. Suggestions on front end development tools
  174. Advise: DTS
  175. Need your help with Microsoft Reporting Services
  176. OUTER JOIN problem
  177. Connecting to Analysis Services using HTTP
  178. Saving text to MS-SQL...
  179. Represent a value list as a table for Outer Join????
  180. Changing Data Format On Select
  181. How to connect to a MSSQL 2000 OLAP Server
  182. Strange SQLCloseCursor Problem
  183. user defined function issue
  184. Variables in SQL Statements
  185. Bulk inserts to Data Warehouse - Best Practices?
  186. SQL Web Administrator calls Visual Studio?
  187. Can't import Access DB into MSDE
  188. Pulling 2 values from 2 textboxes displayed in a third
  189. Showing friendly values in the GUI
  190. XP_SQLMaint
  191. Replace SQL server in multiple server network
  192. Replace SQL server in multiple server network
  193. Need help with query or possible Stored Procedure
  194. CAlling a sp outside a transaction
  195. Linked Server on SQL2000 to DB2 - desperate...
  196. Delete using another table's values
  197. Temporary table problem (maybe)
  198. Microsoft Reporting Service
  199. Front-end tools -- Which is the most productive?
  200. Database server connection
  201. How many records in a table?
  202. Replication: Transactional: Multi Publications, One Subscriber.
  203. Can't change datatype???
  204. How do I change the owner from a table in a database
  205. Timestamp Conversion
  206. Using a Select statment for the name of the field?
  207. Design Question
  208. Mailing Lists
  209. Runtime error data provider or other service provided an efail status
  210. Subform problem with unique-table-property set in access adp
  211. Print the Table Structure
  212. How to print the Table layout
  213. image question
  214. Replication as backup
  215. Outsourcinng is being outmoded
  216. Function that returns highest of two columns?
  217. Synchronization of multiple clients
  218. Removing Tuning Wizard Indexes
  219. Stored procedure to grant all users db_owner
  220. Record Snapshots
  221. convert date to MMDDYYYY
  222. Variable Arg Lists to PreparedStatements
  223. Need help with MS SQL research
  224. [webcast] SQL Server 2005: Integrating SQL, XML, and XQuery
  225. full database backup
  226. Missing Record - Phantom Record
  227. Query could not be processed. Access is forbidden
  228. Using Transaction log to update another database
  229. YUKON Setup Failure
  230. index questions
  231. What is the best way to move data from...
  232. Need help with Stored Procedure
  233. Datetime condition in 'where' - international problem
  234. Extended Stored Procedures DB-Lib Alternative
  235. Choosing DB Edition (Std vs Ent)
  236. DTS to add a field on imported data
  237. Entity Relationship Management Idea
  238. Very long rich text information - datatype?
  239. Remote Sync -- SQL 2000
  240. Optimization advice
  241. DTS Job hangs on 2nd DTS Task
  242. Hide databases in SQL EM from dbo owner
  243. Yukon - will it support sequence object?
  244. DB2 LINKED SERVER
  245. proc argument type array
  246. SQL Server 2000 - how do I change the name?
  247. Problem: mssql locks several records in a specific table, while no one is editing them
  248. Can a new field be added to an existing table.
  249. ERROR 1141 on mySQL creating a User on NT 4.0
  250. Anybody used the universal table broswer?
  251. How to see contents of image column
  252. Table updates -- SQL 2000
  253. Transaction-style Inventory?
  254. SQL Replication
  255. performance problem with linked sybase tables
  256. replicate a database automation
  257. sql batches in vs.net
  258. Report effective permissions for all users?
  259. php integration
  260. SQL Server Components
  261. DBCC PROCCACHE question
  262. OPENROWSET to Access error
  263. ETL library
  264. intermittent openquery error "..The OLE DB provider 'MSDASQL' indicates that the object has no columns.."
  265. Converting Access qrys with logical expressions
  266. Searching question....
  267. Inserting into two tables with one sql statement
  268. Querying single table for multiple summaries - how?
  269. xp_sendmail blocks trigger ?
  270. efficient select
  271. Is a GUID always unique?
  272. Repliation Between 2 Sites
  273. TPC-C Benchmark Kit
  274. Airline Res System Path finder query
  275. Table and Column request as variables error.
  276. JOINs and SUMs Not Giving Expected Results
  277. Capturing events in a DataGrid
  278. Log Shipping Problem/Question.
  279. Need help with query
  280. Weird Cast operator
  281. Attach DB with corrupt .ldf?
  282. Best way to search for all records (Using a Case Statement in a SP)
  283. Transaction Log Rollback
  284. Sql query with a stringfunction
  285. request data from specified time
  286. Disappearing Data -- SQL 2000
  287. temp db
  288. Installing SQL 7 On Workstation
  289. SQLServer 2000 Icoon is not visible in the SystemTray
  290. Updating system tables
  291. Cluster recovery from node failure
  292. How to create a database on pendrive using MSSQL 7.0??
  293. SQL-Query Access by Date
  294. How to query database with multiple queries
  295. How to generate Calculated Field
  296. simple system table question
  297. connecting to sql server (within windows domain) through linux?
  298. Case Statement & View
  299. most recent output
  300. Need to convert a date and time to a different format
  301. How to version control in SQL 2000?
  302. Slow SQL performance with Maximizer Enterprise 8.0 SQL
  303. Database Design Question
  304. Seperating the results of sp_dbfixedrolepermission by fixedbroles
  305. how to force a commit in a sp
  306. Running total count in stored procedure
  307. Changing the server name and IP address
  308. Row-Level Locking
  309. Accessing Estimated Query Execution Plan (QEP) statisitics
  310. HELP! Transaction Log Backup!
  311. Using two select statements in IF Exists
  312. faulting module
  313. [SQL-DMO]The name 'tdb_grabowy1' was not found in the Databases collection.
  314. Zombie Transaction in process -2 Blocking other Transactions
  315. Help on a query
  316. does MSSQL have the ability to do "named row types?"
  317. How to stop mssql
  318. SQL Query help
  319. Suggestions for HUGE DB Design
  320. Performance tuning for a stored procedure
  321. Fastest way to delete hundreds of table triggers and hundreds of stored procedures?
  322. sp_Rename Problem...
  323. xSQL Object 1.5 released - Faster, Better, more Robust
  324. Using Views
  325. Virtual Cube
  326. SQL Statement Count NULL Values
  327. Pass global variable into query through dts?
  328. Order By in Subquery + UNION
  329. Best way to update database behind firewall?
  330. Why use a backup device vs. backup to disk?
  331. Windows Open System/SQL - Sr Systems Analyst Position in PA
  332. Case Expression within a Stored Proc
  333. Sorry, ...
  334. Function to call function by name given as parameter
  335. Calling stored procedure from a C application
  336. Drop temporary tables whilst connected ?
  337. Update Query question.
  338. Database record disappear
  339. Superior SQL Builder version 1.5 released
  340. Query to get column name with specific value
  341. How to find the number of database transactions for a day
  342. HELP! Incomplete data in SQL Server table.
  343. updates across servers
  344. SQL Server Connection
  345. Subquery in FROM clause
  346. Need help on Create View
  347. Insert statement which uses a return value from an SP as an insert value
  348. sql select
  349. Capture existing table
  350. SQL 2000 tape backup fail
  351. Page vs Row locking...
  352. select and insert in one sp
  353. What fields are used?
  354. Looking for SQL Databases for
  355. Write from MS SQL to MySQL
  356. Tables not always replicating
  357. converting access db to mysql
  358. ROW LEVEL SECURITY
  359. Restoring backup from MSSQL6.5 in SQL Server 2000
  360. slow sql update MS SQL 2000
  361. configuring locks in awe system
  362. dropserver
  363. Wildcard doesn't match using LIKE '%' on a varchar field, wierd!
  364. Script to Export SQL Tables to Access
  365. Special Character
  366. How to force unique entries in a linking table?
  367. replication - use legato / veritas /or SQL's native replication
  368. Unable to create object error in sp_SendSMTPMail
  369. SQL server notification services : Help
  370. SQL and XML
  371. Counting Occurences
  372. Cumulative weeks
  373. Empty a table before using DTS to append records?
  374. Disaster - moving databases
  375. How to get String representation of a Hex number?
  376. help with data transformations with outer join?
  377. help with data transformations with outer join?
  378. Simple I think
  379. SQL Server Identity Field
  380. FoxPro ODBC Link Servers and the Dreaded 7399 Error
  381. Simple/General SQL Question
  382. SQL Server Identity Field
  383. DTS - import flat textfile into two separate tables
  384. SQLXML classes deserializing.... nothing....
  385. Help with Error Message
  386. DTS Excel Import, Transform - how do I use "OR" clause in SQL Query
  387. script to spot OS/SFW/HDW changes on my SQL servers?
  388. Database and Log maintenance
  389. Stop/Start MSDE Process
  390. SELECT query help - Zero padding
  391. SQL Server and Clipper/dBase
  392. OUTER JOIN with multiple tables and a plus sign?
  393. SQL Server 2000 & MS SP2
  394. auto-number/Identity column
  395. Clean up old SQL Server logins
  396. BCP Order on SQL Server
  397. SQLExecute takes 100% CPU usage
  398. problem with re adding a login
  399. Question on database/table priviledges with sql server
  400. How to view triggers in SQL server
  401. Secure Replication
  402. call a Oracle stored proc in SQL SERVER
  403. phone book lookup query
  404. Running Scripts
  405. ntext and AppendChunk in ASP
  406. user defined fields best design
  407. In SQLServer SI in ORACLE NO
  408. Reset msde sa password
  409. Any structure on Sql Server like WITH ... SELECT structure on DB2
  410. Error catch in SQL
  411. problem with timeouts
  412. Proper table structure and SQL Server limits
  413. Application times out while doing the updates
  414. Showing Records where count(*) is zero (in a stored proc)
  415. UMS.DLL failure
  416. Isql Command line parameters
  417. import dmp into SQL Server
  418. join or subselect ???
  419. detach database, attach database without log file
  420. General network error
  421. sql statement help
  422. Math function
  423. Can Transactional Replication affect Publishing Server?
  424. Enterprise Manager - slow updates when editing tables
  425. loooong columnnames
  426. Query value in between two columns
  427. Real experiences with 64 bit SQL Server
  428. Create Temp talbe
  429. Select .... where the Item.ID is in this array?
  430. What resources does truncate table use
  431. a player team tables design?
  432. Calling All Dynamic SQL Gods!
  433. deleted my database log file, can't reattach
  434. aliasing two columns in SQL
  435. can not access clustering SQL Server after relocation
  436. Query Help
  437. Best DataType for content system
  438. What do they need to know? - SQL Server
  439. Sorting so 0 is at the bottom
  440. SQL Server Data Types for Local Variables
  441. Cursor Based SQL?
  442. SQL Server import speeds
  443. tuningproblem : materialized table instead of view
  444. Query help needed (JOIN)
  445. Logging into Microsoft Logfiles
  446. MU ONLINE
  447. Compare like data
  448. granting permission to create view
  449. Identifying Connection
  450. Migrating large amounts of data from SQL Server 7.0 to 2000
  451. difficult select distinct query
  452. SQL Server 2000 Table Data Types
  453. ActiveX VBScript problem
  454. Changind date formats
  455. Tansaction/locking MSSQL2000
  456. SQL 2005 Express decided to fight SQL Server 7 ...
  457. msde
  458. Creating tables within my application.
  459. Move TempDB Database off of the SAN
  460. Password protecting XO Profession Control Panel
  461. Updating SQLServer db with VBA
  462. sql question - returning multiple rows as one record
  463. Fix my SQL "WHERE" Statement!!
  464. show tables
  465. logshipping setup with two standby db servers.
  466. Fail over - DNS change
  467. Possible to parse a column in a Select statement?
  468. MMC SQL Server
  469. Help with Trace
  470. Acessing SQL Server over the web with shared IP
  471. repair torn page?
  472. MS SQL 2000 and Windows 2003 Cluster
  473. SQL Mail: Outlook
  474. Delete Records From a Table Using Records in Another Table.
  475. Design flow suggestions needed
  476. More Info: Stored Procedure Security Question
  477. Stored Procedure Security Question
  478. Inflated number of records returned when adding bit field criteria
  479. TSQL Perplexity
  480. Decrypt credit card number for Reporting Services Report
  481. URL Parameters
  482. Partial searches over a lot of fields
  483. How to compare two databases using their DDLs?
  484. Geting event from ActiveX into database
  485. Creating UDT from another UDT
  486. WITH GRANT OPTION
  487. Divide by zero error trapping
  488. New Software 04.08.19
  489. Ignore Error in SP
  490. MS SQL Server Merge Replication
  491. sp_change_secondary_role problems
  492. How to concatenate multiple rows into one field?
  493. Updating more than 10000 records SQL Server 2000
  494. Weird issue on client laptop
  495. [?]Restore and Backup problem
  496. Looking for very good SQL Server DTS books
  497. Looking for very good SQL Server DTS books
  498. Looking for very good SQL Server DTS books
  499. General questions
  500. Storing variables from a user-defined function
  501. Starter question
  502. NON DOMAIN AND DOMAIN CONNECTION
  503. Conversion of Access application to SQL Server
  504. Range query
  505. ON DOMAIN AND NOT ON DOMAIN
  506. Versioning
  507. Using SQL server to process the data
  508. Century date conversions
  509. Tidying up of sproc
  510. Automatically create ODBC connections
  511. memory
  512. Derived Columns in one to many relationships
  513. Log shipping role change
  514. Problem creating indexed views with linked servers
  515. Selecting ONLY records from one table having ALL data contained in other table (GROUP BY?)
  516. Need help with designing a query
  517. Bulk insert into views that select from table on remote server
  518. User Defined Function: Convert String value of Table to Table Object
  519. speeding up Dynamic SP
  520. row-by-row process
  521. Check SQL Database offline
  522. Help with more Advanced functions
  523. DB Growth Issue
  524. Return two rows from one rows data
  525. Storing all stored procedures in one database to minimize different connection strings
  526. SQL aggregate fuction and GROUP BY
  527. sintassi per Creare un file .cub a partire da un cubo mssql
  528. track all changes
  529. Convert table using DTS
  530. help with linked server on sql2000
  531. copy two table
  532. Parametrizar nombre de BD (Espaņol)
  533. Joins versus relationships
  534. Problem with FILENAME as @variable
  535. compact
  536. upgrading hard drives, best way to back up and restore SQL
  537. Drop Index on System Tables
  538. Is there such a thing as too many relationship?
  539. permissions with sql server tables
  540. performance question
  541. One column is nullable on the composite key
  542. SQL Server table changes log
  543. Less than, equal to Operator question
  544. Less than, equal to Operator question
  545. SP waits for a delete trigger?
  546. use db-lib to update database records
  547. iODBC vs unixODBC ?
  548. How to catch an exception?
  549. NULL and MAX Query
  550. numbering a query