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. XP_SENDMAIL problem after windows trust with exchange server established
  2. xp_sendmail problem
  3. SQL Server 2000 2GB memory limit?
  4. Formating Numbers with Commas
  5. Formating Numbers with Commas
  6. How to synchronize 2 tables on different sql servers
  7. Constructing Email message
  8. SQL Replication
  9. Does DB-Restore on a different machine omit user/login information ?
  10. SQL DTS package to process a remote OLAP database
  11. How To set delimeters and text qualifiers in a file
  12. How To write An Sql Crosstable Select statment
  13. How To write An Sql Crosstable Select statment
  14. Using DTS to move data to a new table with some datatype changes
  15. HexToInt, vbintoHexStr - fun with CAST
  16. how to add 1 to the field
  17. Help with SELECT Query
  18. Is this correct use of INSTEAD OF Triggers?
  19. Tunneling enterprise manager over https ASP.NET?
  20. Conecting over the Internet for getting data from clients.
  21. Number Data Types...
  22. openrowset - problem in reconnecting to oracle
  23. Help ! Database Still says loading after restore
  24. Help ! Database Still says loading after restore
  25. Select JOIN problem
  26. Wrong syntax in where smth in case ?
  27. Query Analyzer Template files, object browser bug
  28. wil s2k developer edition really work on XP Pro box?
  29. SQL Profiler
  30. DTS of data between two tables, same field names but differnt datatypes
  31. Sending external email from within a Scheduled Job
  32. What is purpose of N in SQL examples?
  33. cursor insert with like '%'
  34. DTS vs Datastage or Informatica
  35. Connecting for entire session, or just when performing an operation?
  36. How do you lock an entire table?
  37. Crosstab queries
  38. User interaction with SQL
  39. BULK INSERT row terminator
  40. Help Please - Backup FileGroup and Restore
  41. MDX Query Book
  42. Stored Proc not updating multiple rows
  43. DBA on mulitiple databases
  44. 7.00.1078_enu.exe on msde
  45. Problem returning a datarow
  46. Storing binary files in MS SQL 2000
  47. simple SQL update
  48. How can I INSERT w/Constraints in other tables?
  49. SQL 2000 - 450+ Databases
  50. Loop through a recordset to populate columns in a temp table
  51. HexToInt and HexToSmallInt
  52. update from ...?
  53. SQL update statement in VB
  54. Field not being updated within Stored Procedure
  55. Complicated SELECT Problem
  56. Book and class
  57. How to delete rows in a table when no primary key is defined
  58. Primary key
  59. Database Modelling in UML
  60. Mails are stuck in the Queue Folder
  61. odbc errors on terminal server
  62. XML to View
  63. SQL problem
  64. DTS package doesn't execute
  65. Totally shameless self-promotion
  66. Sql server authentication not set
  67. Error while running xp_cmdshell
  68. timeout expired w/SQL2K SP3
  69. any SQL guru's out there?
  70. DEFRAG disk drive
  71. Need good idea
  72. Problem using CAST with Zeroed out Field Values
  73. How can i get the details of the error
  74. Very large number of rows
  75. Will MSSQL DB Server perform better with 2k3?
  76. Database design, inherit
  77. How to get the status?
  78. User-Defined string Functions Transact-SQL
  79. Changing the default port number and still connecting
  80. Need advice for process of swapping DBs
  81. How to convert recursive function into recursive stored procedure
  82. Crosstab query
  83. Database Backup Security
  84. Separate an And/Or parameter
  85. Best way for a Set-based query
  86. Recovery and Backup
  87. ODBC and MSDE
  88. Customer IDs without identity
  89. SQL Server -> MS- Access VBA
  90. persisting data for a pluggable tree
  91. What hardware to get?
  92. generating auto sequential numbers
  93. case, joins and NULL trouble
  94. PRIMARY Files
  95. Install Client Connectivity (SQL Server 2000) Only w/ Less Files?
  96. Write only database
  97. sp_elpuser rights
  98. Mail Profile disabled in SQL Server Agent Properties
  99. Linked Servers - Postgres 8.0.2
  100. Ignore Triggers
  101. checking success of a request in a stored procedure
  102. Session State InProc. HELP??????
  103. can't print variable
  104. Timeout Expired Error
  105. Monitoring Data file size
  106. Splitting of database
  107. don't permit manual access to database
  108. Frontpage 2002 & passing an SQL variable
  109. Snapshot replication
  110. SQL - query improvement MAX(date), IN
  111. Problem with dbo.sysindexkeys in SQL 2000
  112. Creating a trace file with the date appended to it's name
  113. SQL Server & MSDE on same machine?
  114. Help with DTS script
  115. Linking Two SQL Servers
  116. Can I ghost an SQL server?
  117. Tables get Locked
  118. MS SQL 2005 Express
  119. Count of related records??
  120. Net Send Failure
  121. Monitoring Deadlocks
  122. Best way to create dynamic update statement
  123. Edit .mdf database
  124. importing a .txt file
  125. SQL Backup procedures...
  126. Installing MSDE2000 for Remote Connection
  127. Noob: Why does this Query work?
  128. concatenate where clause
  129. Moving db across the country- full copy, then differential?
  130. Inserting Records with limited privileges
  131. Scripted delete rows
  132. SCOPE_IDENTITY with ASP
  133. A query that chooses non-matching items
  134. Counting based on a field combination
  135. SQL Server Hot Fix Install Error - dbmslpcn.dll is WRITE LOCKED
  136. Enterprise Manager Collision
  137. Views Are Deleted
  138. quey help
  139. Storing a month
  140. Storing a month
  141. problem with OUTPUT params in Stored procedure
  142. not exist in place of outer join
  143. Dates incorrectly being saved incorrectly. DD and MM swapped round ?
  144. Primary key on combination of nullable fields, at least one not-null
  145. SQL statement
  146. create database at shared hoster site
  147. Refresh data from production to development
  148. SQL datetime from incorrect char(10)
  149. Interesting Problem
  150. SQL Server on Windows XP Workgroup
  151. paradoxical query results?
  152. Int versus Char primay key performance
  153. Tables seem too big - timeouts happening
  154. SQL Server Distribution Server Licensing
  155. SET FMTONLY being added to in-line SQL
  156. Proyectos de Inversion en IT en la UTN
  157. what does [dbo].[Accounts] mean?
  158. web hoster only allows 1 sql server database
  159. problem in registering sql server in enterprise manager
  160. query result as comma-separated list
  161. Last edit time?
  162. Installation Issue
  163. compare
  164. Question with filegroups
  165. help with query
  166. I need help connecting Access 97 to SQL Server 2000
  167. IsNull Evaluation within EXEC
  168. Parameters in Reporting Services
  169. Database Environment Naming Production -vs- Development
  170. restore from command line
  171. SQL to find short, fat and stupid people
  172. Strange Problew with user defined function or stored procedure
  173. Get lowest date
  174. How to reinstall RS Standard Edition on top of expired RS Eval edition
  175. Format display of current row
  176. Connecting Access Front End to Remote SQL Server
  177. Connecting Access Front End to Remote SQL Server
  178. Modifing the row that invokes a trigger from within that trigger
  179. instead-of trigger and contraints
  180. Advantage of Temp Table
  181. VBScrip Type Mismatch Error
  182. Diagram of Master DB
  183. Linked Server gives Internal SQL Server error
  184. prevent DELETE and/or UPDATE
  185. binding SQL server to localhost?
  186. Cache HIT ratio problem
  187. Would you please suggest a good backup tape drive?
  188. Verify dynamically specified table exists
  189. command line
  190. DBA HELP: Performane Tune SELECT, SUM, & CASE
  191. QA tells me my table is ambiguous
  192. Breaking up a Table
  193. query analyzer returning messed up data
  194. Call DTS package from VBA/Excel?
  195. MS SQL Server 2000 / MS Access - ODBC connection question
  196. Lost My Diagrams
  197. New SQL Server and Photos
  198. I dont have any backup of my database, but I have the mdf's and ldf's files
  199. How to get parameter passed to SQL query from access
  200. Creating a view from a linked server
  201. How to comment a server template
  202. How do ITables moved to a new FileGroup ?
  203. Sum of hours by week
  204. Destination Columns Question
  205. Remote access to sql database...permissions
  206. Using MSDE and moving databases
  207. Help! Cygwin X slows down Query Analyzer
  208. How to copy db from test server to local machine running MSSQL2000 Per.
  209. Inserting a record for each separate aggregate (solved)
  210. Import RIS format to SQL Server?
  211. Run DTS in safe way.
  212. Neq to SQL
  213. How to fetch or store a BIGINT using dbExpress and Delphi 2005
  214. Deadlocks in Profiler
  215. DBCC SHOWCONTIG inconsistency????
  216. Access Violation on Saving a DTS Package
  217. Assistance developing Query
  218. Convert variable into dynamic select
  219. Windows groups for SQL Server - what am I doing wrong?
  220. Run DTS package
  221. Primary Key
  222. Move mdf/ldf files for a replicated database
  223. Gather Meta Data
  224. Checking datatypes of a field accoss multiple tables
  225. How to call functions via ODBC
  226. Learning SQL Server 2000
  227. Date problem in SQL Server
  228. Data Parsing in SQL Server views
  229. Changing collation for tempdb and model
  230. Changing collation for tempdb and model
  231. Changing collation for tempdb and model
  232. Design Problem...Please Help!!
  233. Char to Bit
  234. SQL Server Agent - E-Mails
  235. Help with update query linking 3 tables
  236. sp_configure missing - need to allow updates!
  237. Alias has confused me.
  238. sp_configure missing - need to allow updates!
  239. time-series SQL code.
  240. Log Shipping Transaction Log Question
  241. 100,000 lock requests/sec
  242. [TRANSACT]Can't switch from master to another database
  243. "Users shopping for A were also interested in B"
  244. SQL Server Query Optomizer
  245. xp_logininfo and Domain Local groups
  246. "Unable to validate product key"
  247. Help with JDBC Driver
  248. Object Owners.
  249. Compare data in Tables
  250. MS SQL Server 2000 Log Shipping problem
  251. Getting error c:\windows\system32\odbcad32.exe error
  252. International Motivation Survey
  253. Need one Query to obtain results I can only get with two queries
  254. Transaction Replication & Data archiving on SQL server 2000
  255. SQL gurus, please help
  256. Connection problem from Access front end application to SQL Desktop Engine backend
  257. Strage characters displaying in Enterprise Manager 2000
  258. Return Type of COALESCE?
  259. Strage characters displaying in Enterprise Manager 2000
  260. Using DTS Global variable in task
  261. Creating a Select statement with subqueries to 3 other tables...
  262. SQLDMO - Operating System Cannot Run %1
  263. Microsoft Access doesn't support design changes to the version of Microsoft SQL Server
  264. Seaching mulitple fields?
  265. Importing txt files with sql server 2000
  266. Do's and Don'ts of SQL
  267. Reorganize data and index pages
  268. Unhandled exception in mmc.exe: : Access violation
  269. How to solve "Tables or functions 'inserted' and 'inserted' have the same exposed names. "
  270. Openings in an online game company for sql coders
  271. Return results of mulitple select statements in another Stored Procedure
  272. Query runs slower when converted to a view
  273. Poor performance for business day calculation from aspfaq sample
  274. Database design
  275. Limiting active processes?
  276. Delete with 2 keys
  277. Example of Internal SQL Server Error
  278. SQL Server Best Practice Analyzer and T-SQL coding standards
  279. Merge results from two fields
  280. Problems with joins
  281. Big table
  282. How to assign string value to TEXT output parameter of a stored procedure?
  283. Using an if statement
  284. parameterized pass-through queries from Access front-end?
  285. Optimization of a select query
  286. Maintenance Microsoft
  287. A little script help
  288. SQL Server Backup Applications
  289. HELP PLEASE. Query Question.
  290. Help with a Join and Duplicates?
  291. How to extract part of a string
  292. How to upgrade a stored procedure this way?
  293. Help with dynamic SQL Stored Procedure
  294. SubQuery or Temp Table?
  295. Database Design
  296. Inserting data to tables belonging to different databases
  297. howto check the sql server edition from code
  298. Paper about SQL Server 2005
  299. New to MS Sql
  300. Data transfer
  301. Convert a existing SQL Server 2000 database to 2005
  302. System DSN / Registry
  303. SQL SERVER DBA/ ATLANTA
  304. relation & query
  305. remote stored procedure on MSDE
  306. Fastest way to handle the search
  307. naming column names
  308. help on query
  309. MSDE installation fails due to detection of previous installation
  310. Table size and Computed Columns
  311. trying to avoid using cursors!
  312. How to Go From a Database to A Calendar Format?
  313. Help with 1205 Not raised
  314. cursor vs. select
  315. ASP + SQL loads really slow over intranet
  316. Insert produces error
  317. HELP - SQL Server 2000 Install Files needed urgently
  318. User input in SQL2000
  319. Can stored procs run after handle is closed?
  320. Restore Log Fails Msg:3433
  321. Date Display
  322. Error on link Servere
  323. Dev. Team - Keeping Three Tiers in Sync
  324. How to add 2 columns together
  325. SQL 6.5 migrating to SQL 2000
  326. Import XMS into SQL Server 2000
  327. NTEXT vs NVARCHAR for large number of columns
  328. Crear una BBDD desde VB.NET
  329. Memory Mgt in SQL SERVER
  330. Enterprise Manager Date format has changed
  331. Copy a database
  332. How to backup a database into a number of smaller files ?
  333. loop through a datagrid
  334. SQL Like.
  335. MS ACCESS - ON DELETE CASCADE Problem
  336. Query Optimization
  337. sp_send_cdosysmail - Parameter Inside Body of Email
  338. can't do that request
  339. owner of a temp table
  340. Accomodating 'Dummy' Data?
  341. Problem with query and date ranges
  342. Error processing cube with disabled lowest level of shared dimension
  343. Locking Problem: SQL Server
  344. How to copy tables from local machine to remote SQL server
  345. isql error message
  346. Dynamic Build SQL in store procedure based on select
  347. bcp is inserting blank space for empty string
  348. Is it ok to use 100% of SQL Server CPU?
  349. SQL 6.5 - to - SQL 2000 replication
  350. parse XML strings in SQL text field
  351. 3 quick queries
  352. Insert value in an auto-identity column
  353. My db grew 8.2GB in two weeks BUT only 4MB of data added
  354. INSERT violates primary key. Which way out?
  355. Cannot Generate SSPI Context
  356. Distributed transactions with multiple instances of Microsoft SQL Server
  357. email on insert
  358. Enter Default Values for all columns in all tables except Primary Keys
  359. update fields with searched first date record fields
  360. SQL Query Help
  361. Re-using a calculated sub-select field in a view?
  362. What is wrong with this procedure?
  363. help with santax
  364. How can i copy data
  365. Copy field data from table to another
  366. (((((((((( Anyone know where I can pickup MS SQL 02? ))))))))))))))))))
  367. ((((((((( Can someone post SQL 03 program ))))))))))))))))))
  368. NULL values and Indexes
  369. Installing Without CD - Help
  370. Obtaining business hours based on start and end date
  371. Domino VBA
  372. Domino VBA
  373. Is Physical server name stored in the Master database
  374. Renaming logical file names
  375. Utilizing compound indexes
  376. Converting tables to Upper case
  377. Selecting single sorted row from many column
  378. Profiler Trace file format
  379. Join using max value
  380. ZZZZ New text 1/1 New Text Document.txt (1/1) 18
  381. ZZZZ New text 1/1 New Text Document.txt (0/1) 18
  382. filelistonly vs verifyonly
  383. How to connect using C#
  384. audit trail triggers
  385. Checksum not working
  386. Exam 70-229
  387. exec sp_executesql vs. sp_executesql and performance
  388. Need help in Updating multiple rows
  389. CHECK Constraint to prevent a conditional duplicate
  390. Transaction MS SQL
  391. SQL Enterprise Manager and Query Analyzer displaying different Row Counts
  392. Database definitions
  393. urgent
  394. Oledb stored procedure rowset binding
  395. GROUP By clause or DISTINCT clause
  396. Specific Book Recommendation
  397. Question on using patindex
  398. Server not using all available memory.
  399. Grouping columns
  400. Importing Access databases into SQL Server
  401. What is Cardinality
  402. 'Suspect' DB won't open - OS error 32- Help!
  403. Inserts gradually slow down
  404. Need help with complex(?) querie
  405. SQL Union with ORDER BY
  406. isqlw.exe
  407. Restore Production database to Development
  408. Duplicate Reference Numbers using MAX()+1
  409. sql charindex split string
  410. Determine Quarter End and Beginning Dates
  411. owner data objects
  412. Transaction log shrinking... weird behavior?!?!?!?
  413. SQL Server: command line support
  414. Connecting to SQL Server 2000 on another subnet
  415. Count consecutive numbers
  416. Front-end website search using Full-Text
  417. local data
  418. .RMD or RMX. to sql server
  419. Which is better? Int or smalldatetime(MSSQL)
  420. SQL Server 2000 and Windows Server 2003
  421. Many databases vs. 1 database
  422. a new SQL tool to help maintain SQL code is now out
  423. a new SQL tool to help maintain SQL code is now out
  424. Restore database fails because database is in use.
  425. More on mysterious data loss in mssql2k - a possible solution?
  426. read only database performance question
  427. Dynamic Column amount query
  428. Can someone explain this behaviour?
  429. top keyword and sorting
  430. can't do that request
  431. Count the number of cubes
  432. Column Names with a cursor
  433. Sample ASP Script??
  434. Database backups growing exponentially
  435. sql service run as question
  436. How To PROTECT SQL Server Database Files ?
  437. Database Move
  438. Mysterious loss of data from mssql2k
  439. Great News Blog!
  440. Query problem
  441. Having Trouble Installing Reporting Services
  442. Help with query
  443. Interesting issue with Full Text Search
  444. Tough little trigger
  445. SQL Server Performance
  446. Need help with SQL query
  447. Virtual Server 2003 Issue! Access Denied- Admin web screen !!
  448. Process not getting any memory
  449. Dropping FK Constraints in a Stored Procedure
  450. C#, SQL-DMO, Add FileGroup Issue.
  451. Insert SP results into variable?
  452. No longer need default instance of SQL Server
  453. basic sql question
  454. SQL Server 2000 Table Auditing for HIPAA
  455. Log Shipping Problem
  456. sql server replication performance
  457. Recursive Query ??
  458. Getting SUM Function Result
  459. Executing sql statements
  460. Syntax for updating table variables
  461. Handle SQL errors with severity 10
  462. Timestamp problem!
  463. Error 15401 adding login to SQL Server
  464. SQL database structure question
  465. How display number records in query designer VisualStudio.NET
  466. help on a sql request
  467. Views / Stored Procedures / Updating Records
  468. Compairing updated data base.
  469. Calling Encrypt2 function from Sqlserver select query
  470. manage transaction to avoid locks
  471. Virtual Primary Key = Slow
  472. SQL Server Scalability
  473. SQL Mail
  474. Help! SQL Server error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ...
  475. access 03 query datashet view problem help
  476. Combine two queries - help please
  477. Import Password Protected File Via DTS
  478. using count somehow
  479. Is it possible to write a format file that skips a few bytes of header in data file?
  480. How do you export?
  481. Dataset Code Debugging
  482. Altering functions and CHECK constraints
  483. Results of SQL SELECT statement into Stored Procedure
  484. Server Reboot
  485. Replication Problem
  486. View Optimization?
  487. SQL Connections using NAT
  488. Updating a field for multiple records
  489. C#: Running DDL to Create Functions.
  490. search engine in SQL server ?
  491. slecting a table using a local variable name
  492. Need help with query that does both timediff & sum
  493. copying data and structure from one database to another
  494. Please help: Create View
  495. Please help: Create View
  496. stored procedure question
  497. Inserting multiple rows with a single INSERT INTO
  498. Cacluated Field
  499. smalldatetime and sorting
  500. Derived Fields
  501. To compare fields between two table
  502. union with sub query
  503. Data import - foreign key question
  504. urgent DB export issue
  505. Vote on a new newsgroup proposal
  506. Windows 2003 - SQL server does not exist or access denied
  507. T-SQL Help
  508. Unable to create a step in a SQLServer Job
  509. Can't connect to SQL Server (developer edition) from another PC?
  510. Help with java connection to MS SQL 2000 with windows integrated security
  511. automatic rename in FROM clause of dependant objects ?
  512. typical audit trail ?
  513. difference between SYSTEM_USER and USER
  514. How to find max from a table by row
  515. HELP: REGEXP accurences count
  516. Inserting to table with dashes in fieldnames
  517. Calculate/create Row Number without identity
  518. sp_attachdb time varies
  519. Exists query with priorities
  520. Date range problem
  521. BCP and Bulk Insert to Linked Servers
  522. How to simplify my endless query. Thanks.
  523. question on trigger/procedure plz reply?
  524. Question on FOR XML issue
  525. sql query help
  526. Help with SQL if statement and adding fields together
  527. treat contiguous records as 1
  528. quick question on SQL server and object support
  529. Null How to handle
  530. Table Design Question
  531. Stored proc location
  532. Change data type during INSERT INTO ?
  533. Urgent
  534. Finding last "whitespace" character in a string?
  535. Question on Idenity Columns
  536. How to handle this Linked Server error trap in SQL2K?
  537. Setting up backups
  538. Parse a numeric string from a field
  539. updateblob
  540. Switched to simple recovery model when will the transaction log shrink?
  541. limiting result set from MS SQL Server Query
  542. How to get info in SELECT directly instead of UPDATE? Thanks.
  543. Can you qry sys tbls to find Triggers, Constrants etc?
  544. How to build database to support user-specified entities and attributes?
  545. Poor performance
  546. working with xp_sendmail
  547. AND query in single column
  548. Stopping a script
  549. How to get a batchjob to run on more than 1 processor ?
  550. SQL Query to return rows only when a max limit on SUM has been reached.