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. Need MAX from Each Group
  2. get DB name from within stored procedure?
  3. MSSQLSERVER service terminated unexpectedly
  4. Help with an import to SQL
  5. Problems running Enterprise Manager and Service Manager
  6. Data Retrieval From Online Database - Paid Consultant Required
  7. Media question
  8. Formatfile shortcut?
  9. Bulkadmin role (BULK INSERT)
  10. TOUGH INSERT: Copy Sale Record/Line Items for "Duplicate" Record
  11. question abot primary key
  12. Very serious bug with Materialized/Indexed views and SQL server
  13. Unicode in SQL queries
  14. Unix connectivity tools to sql sever 2000
  15. Unix connectivity tools to sql sever 2000
  16. Table Spool\ Lazy Spool
  17. Database restore question
  18. Recordset opens as read-only -- WHY??
  19. INDEX possible for reverse wildcards?
  20. Altering SQL Server 2000 table design
  21. Large Data Delete
  22. Data Modeling
  23. WriteBak Reaktime examples
  24. Count rows in a date interval
  25. Help with getting table information from sqlserver
  26. query regarding date format
  27. Print list of tables with Identity row set to NOT FOR REPLICATION
  28. OPENDATASOURCE: text file as input ?
  29. Build database application on Internet with ISP?
  30. Operating system error code 3(The system cannot find the path specified.).
  31. Setting maximum number of merge agents
  32. Volltextsuche mit contains
  33. SQL 6.5 with Delphi 1.0 on Win95 problem.
  34. Migrate VIEW from Access to SQLserver ???
  35. Input string was not in a correct format
  36. eliminating redundant data
  37. NULL vs. "Unknown Value"
  38. set a attribute to random values in a given list
  39. Logging to second disk -- what happens when it crashes?
  40. Representing rows as columns
  41. MSDE Maintenance Plan
  42. Comparing data in two consecutive rows from a single table
  43. Sum question
  44. accessing SQL 2000 table from within Excel
  45. HELP! Shopping Cart Solution Required. URGENT!!
  46. Count query problem :(
  47. slow query thousands of records.
  48. solve the proplems
  49. DTS Import not working after SP3a upgrade
  50. Generate a normalized XML doc from SQL Server
  51. Instances of SQL
  52. Nested Coalescing possible in SQL?
  53. Fundamental Functions MS SQL Server 7 or 2000 users VALUE MOST
  54. Control characters output in attachments from xp_sendmail
  55. Convert to Date
  56. Is any possible to run DTS package from Command Line ?
  57. SQL Query - Date, between dateadd problem
  58. wildcards in dropping constarints
  59. Selecting Values in CSV
  60. Advance SQL
  61. Help Required on Stored Procedure
  62. Possible Corrupt Table
  63. cross tab or derived table
  64. Creating roles
  65. can u help with my select ?
  66. cross tab or derived table
  67. Like statement
  68. sql server 2000
  69. possibile che ...
  70. Calling All T-SQL Gods & Goddesses
  71. How to Spec a SQL server
  72. SqlServer changes cursor to "read only"
  73. Yet another BCP issue
  74. Scripting "INSERT"s in an SQL database?
  75. Help setting up SQL2000
  76. CASE with empty parameter
  77. multiple result sets
  78. PRINT command Not Working For Database Client
  79. Select lookup code values problem
  80. How to transform fact table only by SQL?
  81. DBCC and Failed Assertion Errors - HELP!
  82. Why is my Data Import going so slowly?
  83. Full-Text Search Query Question - Performance
  84. SQL for Modeling Generalization Hierarchies
  85. Breaking out data from a text field type
  86. Functions with global variables
  87. update tables from a csv file?
  88. Who is in a database ?
  89. connection problem to sql 2000 on windows 2003 from Windows 95
  90. HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET
  91. Whats wrong with this nested while loop?
  92. password protecting data
  93. Problem in Right Outer join query
  94. Defining global function in DTS
  95. BCP utility replaces German with junk characters
  96. Right outer join problem
  97. Advanced SQL Query Problem ...
  98. Problem with a temp table
  99. Timeout / Obtaining a connection from the pool - Please Help!
  100. select into withidentity
  101. question about retrieval of client process IDs
  102. Update Top 30%
  103. last row
  104. how to drop all keys & indexes
  105. Update all tables in database
  106. Triggers
  107. Disabling primary key
  108. stored procedure result set
  109. last day of previous month
  110. long query alert
  111. changing one column in each row
  112. Access linked to SQL Server - 2 day offset error
  113. FOR SELECT
  114. Embedded select query?
  115. SQL Server makes our server reboot!
  116. Insert into two tables, both with auto increment fields
  117. Sudden xp_send mail error
  118. SQL pieces-parts
  119. Query: How can I get this result?
  120. Adding Identity Column to BIG table
  121. Date/Time select Problem
  122. are nulls bad
  123. Novice question regarding client notifications from a server
  124. Mapping SQL Server Data Types to C DataTypes
  125. Query to get the Domain from the email
  126. script to remove nulls from DB?
  127. Wrong record retrieved after move to SQL Svr
  128. Log shipping wizard doesn't show up in Enterprise Manager
  129. Cretae a view in one DB with a stored procedure from another DB
  130. Sql server-compi question
  131. @local_var really cannot hold table name ?
  132. Which is faster?
  133. data types
  134. Trouble with Update syntax
  135. Conversion Problem
  136. Correlated Subquery with distinct Record
  137. Inserting a select with an additional static field
  138. deadlocks in sql server
  139. Query in a Loop
  140. case-sensitive search in sql 7
  141. SQL Server DB Backup job problem
  142. Log Shipping for replication
  143. Performance Tuning for Row-by-Row Update Statement
  144. Displaying images clarafication
  145. Allow zero length
  146. 3rd party tools for job scheduling
  147. noob question how to make a mailto function
  148. NooB Scripting Question How to use mailto
  149. Date functions
  150. Stored Procedure Across SQL Servers
  151. Using alias in an expression
  152. Spacing problem in SQL Server
  153. Query too slow
  154. Tricky Record Locking Problems
  155. find missing/deleted records?
  156. Book recommendation on performance
  157. Closed transaction keeps running...awaiting command
  158. 1:m database relation "Flattened" for reporting purposes
  159. Performance problems with query
  160. SQL 7.0 to 2000 upgrade
  161. Risks of single MSSQL domain account for mult servers?
  162. MSDE and SQL Server 2000 design questions...
  163. sql server 2000
  164. Mainframe Datatype Scrubbing
  165. Securing mdf file
  166. unable to submit more than 8000 characters with stored procedure
  167. Backup/Restore locks up EM
  168. MSDE and NetUserAdd Error
  169. Analysis Services
  170. Update stmt with an Table alias?
  171. Access vs SQL
  172. Sql 2k Database Log file Full ... How to empty that
  173. Filter Criteria - Temp Table Join or Where clause?
  174. SQL Server Report Generator - beta testers needed
  175. TempDB Disk placement with Log files?
  176. Enterprise Mgr Can Not Sort?
  177. Linking to MS Word
  178. 'Primary' filegroup is full.
  179. Select Max query - please help
  180. Nulls in calculations
  181. Something like MIN(f1, f2)...?
  182. Can table ownership be changed?
  183. Help - how to concatinate strings from multiple rows?
  184. Translate Function?
  185. data dictionary
  186. SQL Server Performance varies by NT account
  187. Sorry: Trying to understand this piece of code
  188. help with sql script
  189. eseguire un dts
  190. update data in a field
  191. Which Raid?
  192. pick list values into a table
  193. multiple values into a table
  194. Recovering from transaction log deletion in 6.5
  195. MSDE
  196. MSDE
  197. A question of SP technique...
  198. MSDE & Web Pages
  199. memory utilization
  200. SQL Mail and SQL Agent Mail @!~$%!%#^$%&^#&#%
  201. export view table into excel
  202. Sintaxis mysql
  203. Is it possible to re-reference a column alias from a select clause in another column of the same select clause?
  204. CPU 100%
  205. "dbuse" fails when database name is larger than 28 characters
  206. xcopy command failed in sql server 2000 as scheduled task
  207. Entry point not found with MS SQL Server
  208. "GO" used in a stored procedure
  209. Exporting to Excel
  210. How do I copy a database
  211. View & SP's for just a few users
  212. row number.
  213. Can not create views, tables etc * URGENT*
  214. Caching UDF
  215. decreasing number of records.. is it important?
  216. MS-SQL Server equivalent to Oracle 9i?
  217. Anything wrong with this query?
  218. Help with TEXTCOPY
  219. Difficult query help
  220. help with nested Query
  221. Difficult query: return recordset from concatenated strings?
  222. Creating New Views on SQL 2000
  223. tempdb log full
  224. Link Pervasive SQL Server - how ?
  225. sql server sizing planning - architecture help
  226. DTS vs Excel numeric conversion
  227. Oracle9i: SQL Exam# 1Z0-007 wanted
  228. SELECT DISTINCT with JOIN
  229. how to break out of a cursor and out of a SP all together
  230. Looking for a db schema read/write/synch tool
  231. Representation for Deleted Entities: difficult question
  232. TSQL to run DBCC rebuild_repair on an MSDE 2000-hosted DB
  233. Database Design Question
  234. ms access query problem
  235. SQL Mail
  236. PK
  237. SQL Server Job Wanted - Philly Metro Area
  238. More on dependecies
  239. DTS Package is dropping trailing spaces
  240. Logging Sql queries
  241. Stored Procedure Syntax
  242. Data Access Laws In the UK
  243. How to Modify a views' SQL source from a program
  244. Scribe Report Generator - beta testers needed
  245. DTS package and Firewall
  246. Locks and "forever runnable" processes
  247. Calculating Hours with Overlapping Times
  248. can't connect to Oracle
  249. uso del top en el mysql
  250. one frontend different type of backends
  251. SELECT DISTINCT
  252. Total SQL users?
  253. SQL use statistics
  254. Alias name for addressing SQL databases
  255. How do I avoid this corelated subquery?
  256. How do i grab a simple list of SQL Server views, tables or sprocs?
  257. SQL and ASP
  258. SQL and ASP
  259. Index Tuning Wizard - headache
  260. SQL server and ASP
  261. SQL SERVER DBA
  262. convert Access DB to MS SQL with dtswiz(command line)
  263. SQL Server 7 switches to Windows Only Auth on Reboot
  264. How to redirect a DTS package and connections
  265. Stored Proc Recompiling over and over
  266. Get message : The query cannot be excuted because some files are missing...
  267. Remote hosted database - SQLServer 2000
  268. DB increased the size
  269. FTP from within T-SQL
  270. Database Wars: Oracle vs SQL Server Lock Escalation
  271. sqlserver access datatype differences
  272. SQL funnies :o)
  273. Q: Analysis Services Cube Design
  274. REQ:how does one run SQL 2000
  275. Schedule Local Package to perform FTP and DB restore
  276. Check null value of long data type
  277. Query help: need at least one row for each value in each of two columns
  278. Get Current Identity(Procedure)
  279. Generate XML file from stored procedure
  280. Cannot make server as Target server or link from Master Server
  281. SQL server installation reboots my machine
  282. Query length
  283. referencing to a function..
  284. Passing error message to ASP.NET
  285. tuning the sort step of execution plan
  286. How to setup default value using GETDATE?
  287. New version of AbaPerls available!
  288. Help loading data from Excel to Analysis Services
  289. using conditional statement in stored prcodure to build select statement
  290. Help with query
  291. Send formated query result by mail
  292. sql server certifcation website wanted
  293. floating point calculation
  294. System catalog tables?
  295. converting datetime int
  296. Disabilitazione trigger [DISABLE TRIGGER]
  297. Update in SQL Server 2000 slow?
  298. Thoughts about the smart way to a task
  299. Coding in standard SQL ?
  300. 1-multiple to string
  301. displaying related data from a table
  302. displaying related data from a table
  303. PRIMARY file group is full
  304. Recursive Query
  305. Update query
  306. UPDATE query problem
  307. Can There be a single Index
  308. Returning database schemas
  309. I inteded to ask a different question
  310. Maximum Date in a group of records
  311. RDBMS Report Generator - beta testers needed
  312. How to ensure data is no longer on disk
  313. Hiding a SP in Access under Query, but retain Execute on SP
  314. Adding comments to TEXT field...
  315. Inserts failed sometimes ...
  316. INSERT ... SELECT PROBLEM
  317. DTS w/dynamic source & query
  318. problem analyzing logs with lumigent's log explorer
  319. test post - ignore
  320. re-indexing job takes more time
  321. Column Count from Stored Procedure
  322. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  323. Data/Transaction log files for two databases have same file name
  324. SS 2000 Backup programatically
  325. Cannot set job alerts on Notifications tab if a non-sysadmin user
  326. About MDF file
  327. Restore puts copy of user tables in master
  328. sister caught with the kid next store 4033
  329. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  330. problema con la funzione except
  331. Round funtion on entire columns in MSSQL?
  332. Cant create database with > 4 GB log
  333. Update multiple records
  334. Extended SP Questions
  335. INSERT ... SELECT PROBLEM
  336. xp_Sendmail does everything but actually sending the message
  337. DTS w/dynamic source & query
  338. What so special about PostgreSQL and other RDBMS?
  339. problem analyzing logs with lumigent's log explorer
  340. test post - ignore
  341. Equivalent of "Startswith", "Endswith", "Contains" string comparisons in t-sql?
  342. Export & import DTS Packages
  343. ODBC Connect from MS Access to SQL Server 2000-Viable?
  344. re-indexing job takes more time
  345. Column Count from Stored Procedure
  346. Non trovo il link
  347. Importare dati con bcp in sql server 2000
  348. third party sql tool
  349. Torn page error
  350. Comparing and Synchronizing Databases, Tables, Stored Procedures accross servers
  351. Data/Transaction log files for two databases have same file name
  352. Add Keywords to Query Analyzer's Syntax
  353. SS 2000 Backup programatically
  354. Cannot set job alerts on Notifications tab if a non-sysadmin user
  355. Dirty Read ?
  356. About MDF file
  357. Can not install Reporting Services, Help!
  358. Restore puts copy of user tables in master
  359. Merge Replication + Structure Changes
  360. Compressed Drive Support in Yukon (SQL2005)?
  361. sister caught with the kid next store 4033
  362. Retrieve a list of db roles from within T-SQL????
  363. Quale tipo di indice sulla tabella? Wich kind of index on table..??
  364. Compare 2 DateValues -> maxvalue in transact sql
  365. problema con la funzione except
  366. Data Structure -- It's been a while
  367. Round funtion on entire columns in MSSQL?
  368. Using results of query in a query
  369. Cant create database with > 4 GB log
  370. storage snapshot
  371. FlexGrid in VB
  372. alter identity property of a column to NOT FOR REPLICATION
  373. problem passing UDF scalar result to UDF table function
  374. SQL Server Report Generator - beta testers needed
  375. Update multiple records
  376. Extended SP Questions
  377. xp_Sendmail does everything but actually sending the message
  378. Inserting row and scope_identity()
  379. What so special about PostgreSQL and other RDBMS?
  380. Equivalent of "Startswith", "Endswith", "Contains" string comparisons in t-sql?
  381. Reverse Wildcard Searches Impossible?
  382. Export & import DTS Packages
  383. Measure data transfer between replicated servers
  384. ODBC Connect from MS Access to SQL Server 2000-Viable?
  385. Senior DBA Positions in Dallas, Austin, Atlanta.....
  386. SQL Server Alerts...
  387. how to discover either windows group or SQL login
  388. 3 Login failed every second
  389. Non trovo il link
  390. Method Execute of Object - Command Falied(Runtime error-2147217900)
  391. Importare dati con bcp in sql server 2000
  392. How do I calculate the sum of each number in a string of numbers?
  393. third party sql tool
  394. Torn page error
  395. multiquery in a store procedure...
  396. How to find out which field in a table is updated
  397. Help won't open up for Enterprise Manager or Query Analyser
  398. Limiting tables displayed in new window for SQL 2000 Enterprise Manager
  399. percent of executed procedure
  400. SQL Server
  401. how to get online/offline status
  402. Add Keywords to Query Analyzer's Syntax
  403. Migrating StarOffice spreadsheet data to SQL Server
  404. SQL user
  405. Dirty Read ?
  406. Importing Big Text fields with <CR><LF> in them
  407. Can not install Reporting Services, Help!
  408. Assigning parameters in a function
  409. Merge Replication + Structure Changes
  410. SQL Server Object Security
  411. Compressed Drive Support in Yukon (SQL2005)?
  412. How to identify fragmented index for rebuild
  413. How to identify fragmented index for rebuild
  414. Retrieve a list of db roles from within T-SQL????
  415. Compare 2 DateValues -> maxvalue in transact sql
  416. Bin Laden Captured - photos and video
  417. divide INT get decimal output
  418. Data Structure -- It's been a while
  419. Using results of query in a query
  420. After copying a record with an SP all textfields has max lenght
  421. Create a view in VBA
  422. DIsk quotas
  423. dumping data from database
  424. storage snapshot
  425. alter identity property of a column to NOT FOR REPLICATION
  426. FlexGrid in VB
  427. problem passing UDF scalar result to UDF table function
  428. SQL Server Report Generator - beta testers needed
  429. sybase driver
  430. Send email notification for Scheduled Job completion
  431. Output to the log file with XP_CMDSHELL
  432. Inserting row and scope_identity()
  433. LINK WITH SQL SERVER
  434. ISNUMERIC and CAST
  435. Reverse Wildcard Searches Impossible?
  436. Sql maint plan not removing .trn files
  437. Measure data transfer between replicated servers
  438. Senior DBA Positions in Dallas, Austin, Atlanta.....
  439. SQL Server Alerts...
  440. how to discover either windows group or SQL login
  441. User ID limit per database, Msg 15065
  442. DB2 ODBC Error using in DTS (MDAC 2.7)
  443. SQL Server - failure to replicate
  444. 3 Login failed every second
  445. Dynamic Cross Tab Using Cursors.
  446. SQL Web Services
  447. Method Execute of Object - Command Falied(Runtime error-2147217900)
  448. Connected to which database
  449. How do I calculate the sum of each number in a string of numbers?
  450. multiquery in a store procedure...
  451. Performance tuning and measure on MSSQL 2000
  452. OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
  453. How to find out which field in a table is updated
  454. Help won't open up for Enterprise Manager or Query Analyser
  455. SQL 2000: Inserting multiple rows into a single table
  456. Limiting tables displayed in new window for SQL 2000 Enterprise Manager
  457. SQL Server
  458. percent of executed procedure
  459. how to get online/offline status
  460. Migrating StarOffice spreadsheet data to SQL Server
  461. SQL user
  462. Importing Big Text fields with <CR><LF> in them
  463. Open up SQL Server for central server application...
  464. SQL Eliminate Duplicates
  465. reading Transaction Log.
  466. Assigning parameters in a function
  467. Can I carry my existing DB users to a new server and restore???
  468. SQL Server Object Security
  469. Need help
  470. How to identify fragmented index for rebuild
  471. How to identify fragmented index for rebuild
  472. Need Sql statement
  473. Index Performance
  474. Bin Laden Captured - photos and video
  475. divide INT get decimal output
  476. column update function
  477. DTS from Excel to SQL?
  478. After copying a record with an SP all textfields has max lenght
  479. Create a view in VBA
  480. DIsk quotas
  481. dumping data from database
  482. Problem When using Recordset paging
  483. Should SQL concatenation return a null value if one field is null?
  484. Problem: Stored Procedures not completing from Web Application
  485. sybase driver
  486. regarding: Least expensive way to develop SQL 7 or 2000
  487. Send email notification for Scheduled Job completion
  488. Least expensive way to develop SQL 7 or 2000 Database on website?
  489. Sum query
  490. Index is being rebuilt
  491. @ local variable makes query slower?
  492. Output to the log file with XP_CMDSHELL
  493. Count records when RecordSource is a Stored Procedure
  494. LINK WITH SQL SERVER
  495. ISNUMERIC and CAST
  496. Unique constraint index
  497. BackUp Quastions
  498. Sql maint plan not removing .trn files
  499. error in recordsource after converting to sql server 2000
  500. Pre-installed databases?
  501. local system privildges
  502. User ID limit per database, Msg 15065
  503. DB2 ODBC Error using in DTS (MDAC 2.7)
  504. SQL Server - failure to replicate
  505. Dynamic Cross Tab Using Cursors.
  506. SQL Web Services
  507. Connected to which database
  508. Performance tuning and measure on MSSQL 2000
  509. Help for best logic
  510. Sr. SQL DBA job open in Texas
  511. OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?
  512. Installing SQL Server 2000 Developer on Windows XP Pro
  513. SQL 2000: Inserting multiple rows into a single table
  514. Updating statistics
  515. Enterprise manager
  516. Open up SQL Server for central server application...
  517. use of variables - why doesnt htis work
  518. Problems with 'sp_helpdb' stored procedure
  519. SQL Eliminate Duplicates
  520. reading Transaction Log.
  521. Can I carry my existing DB users to a new server and restore???
  522. What is faster? C++ vector sort or sort in database
  523. Need help
  524. Need Sql statement
  525. Index Performance
  526. column update function
  527. DTS from Excel to SQL?
  528. Access Front End and SQL Server 2000 Record Level Access Control
  529. Problem When using Recordset paging
  530. Replication
  531. Executing a reboot command from SQL
  532. Upgrade to Sql 2000 with minimal downtime
  533. SQL Trigger for trimming String fields
  534. Should SQL concatenation return a null value if one field is null?
  535. Help for Trigger
  536. Problem: Stored Procedures not completing from Web Application
  537. Help: Purge Table Stored Procedure
  538. error with linked server
  539. SQL query fails
  540. SQL server reboots my windows 2000 machine
  541. regarding: Least expensive way to develop SQL 7 or 2000
  542. Creating database and table on MS MSQL server
  543. [QUERY] Help...
  544. Least expensive way to develop SQL 7 or 2000 Database on website?
  545. Sum query
  546. SQL daily
  547. Index is being rebuilt
  548. @ local variable makes query slower?
  549. Count records when RecordSource is a Stored Procedure
  550. Replace function and regular expressions