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